Re^2: Performance : process lakhs of database records

in reply to Re: Performance : process lakhs of database records
in thread Performance : process lakhs of database records

Currently i take nearly hundred thousands of record and load it in hash.
After that compare the record values to another table.
It leads to performance issue. Is there any efficient way to improve this.

Comment on Re^2: Performance : process lakhs of database records

Replies are listed 'Best First'.
Re^3: Performance : process lakhs of database records by marto (Cardinal) on Jun 03, 2010 at 13:58 UTC
Why not simply do a database query via DBI and compare the values between the two tables?	[reply]

In Section Seekers of Perl Wisdom