Think about Loose Coupling | |
PerlMonks |
Re^7: Best way to match a hash with large CSV fileby Marshall (Canon) |
on Nov 06, 2011 at 13:58 UTC ( [id://936288]=note: print w/replies, xml ) | Need Help?? |
opps..this is not an "apples vs oranges" comparison.
Talking about 100 seconds is a mistake. The OP asked: The problem with this approach is that the CSV file (40MB) is loaded to DBI engine 5,000 times and takes hours to process. Answer is NO!: The answer that the OP wants can be had very fast and it is related to to the indexing of the database.
In Section
Seekers of Perl Wisdom
|
|