Re: Performance : process lakhs of database records

[JavaFan]

I fail to pinpoint a particular problem in your question. Is it the "how do I connect to the database" issue you have a problem with? Is it "how do I process records"? Is it "how do I write a Perl program"? Is it "please write a program for me?". Please elaborate. And tell us what you've done so far.

[selva]

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.

[marto]

Why not simply do a database query via DBI and compare the values between the two tables?