I agree with CubicSpine and Ovid that you might want to re-evaluate the decision to use mysql. The only advantage to using mysql in these circumstances would be to enhance your perl/database skills. If this were the only consideration then by all means, continue doing so. But, OTOH, if the following are true:

• each record in the file contains only one field, e-mail address.
• once you get the file, you are the only person using it.
• you don't expect that format of the file to change anytime soon (like by adding new fields per record).

Then there is nothing that mysql can do that you can't do faster working with plain text files.

I work with a file that has 48,193 94-byte records. On our ancient Sun Sparc 10, it takes 3 whole seconds to load the entire file and store it in an array. On our Sun Enterprise 350, it takes less than a second.

In my case, however, I have to break each record into 10 fields, be able to sort across multiple non-contiguous fields, perform merges and complex selects. So I should consider using a database implementation even though the file is used only by me and is never updated (except when I replace the entire file weekly).

"Make everything as simple as possible, but not simpler." -- Albert Einstein

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.