What is a 'lakhs of recorda'? Lakh? How do you access the remote machine? What processing do you need to do? See How do I post a question effectively?.

Update: added fourth question.

Update 2: perhaps you mean you have a remote database system containing many records. See DBI and Database Programming from the tutorials section.

"Lakh" is a unit much used in India and thereabouts, and is equal to 100,000.

Paul

Also known as 100 grand pianos, right? :)

Yeah, I linked to the wiki entry in my post under the suspicion that was what OP meant.

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.

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