Re: Re: RegEx Problem?

Since this is just a piece of a larger program, I'd rather keep it all in Perl if possible. And as for file sizes, a similar file that is 6328 lines is about 564k, so figuring ~7.3 million lines, that's about 666075395 bytes, so about 635 MB all together (correct me on my math if I'm wrong).

Comment on Re: Re: RegEx Problem?

Replies are listed 'Best First'.
Re: Re: Re: RegEx Problem? by hardburn (Abbot) on Feb 25, 2003 at 14:53 UTC
As a general rule-of-thumb, a database that is more than 1 MB in size should be kept out of a flat-file and into a real database. Some people suggest even less than that. And when in a discussion about flat-file vs. real databases, you really ought to mention DBD::SQLite. ---- Reinvent a rounder wheel. Note: All code is untested, unless otherwise stated	[reply]
DBD::SQLite by waxmop (Beadle) on Feb 25, 2003 at 21:10 UTC
This is the second time I've seen DBD::SQLite mentioned in two days. I looked at the CPAN page, and the project homepage, but didn't find too much information about how to use it with perl. Would you be willing to post a simple example of how somebody would use it in an instance like this one?	[reply]
•Re: DBD::SQLite by merlyn (Sage) on Feb 25, 2003 at 22:01 UTC
It's a standard DBI plugin. Except for the "DSN" which is specific to DBD::SQLite, any one of thousands of DBI examples will do. That's the beauty of DBI. -- Randal L. Schwartz, Perl hacker Be sure to read my standard disclaimer if this is a reply.	[reply]