in reply to Re^6: Best way to match a hash with large CSV file
in thread Best way to match a hash with large CSV file
Talking about 100 seconds is a mistake.
I don't think that anybody said anything about X seconds.
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.
|
|---|