|No such thing as a small change|
What are effective methods for retriving many number of rows from postgreSQL tables using perl DBI?by targetsmart (Curate)
|on Oct 13, 2007 at 08:12 UTC||Need Help??|
targetsmart has asked for the wisdom of the Perl Monks concerning the following question:
My system has 4 GB RAM, 250GB HDD. Debian etch OS, PostgreSQL 8.1, perl 5.8.8, perl DBI 1.52
so I decided to get the records patch by patch continuously.
a patch is basically 1000.
I did a vast search on the net and found the following methods were useful
- using bind_columns (but more method calls are needed).