Re: [GENERAL] Newbie DBD::Pg question

2001-07-06 Thread Joshua Jore
I haven't gotten into it yet but you could try using the sendQuery method and looping on the new data as it becomes available. Josh On Fri, 6 Jul 2001, Mithun Bhattacharya wrote: > Just started on postgres a few days back and was having a few questions > about the perl interface to it. Accordin

Re: [GENERAL] Newbie DBD::Pg question

2001-07-06 Thread Gilles DAROLD
Hi, Extraction of large amount of data is not realistic especially with CGI, then DBI/DBD::Pg always return all data received from a query so if you don't want to tired your machine, the better way is to use cursor in a transaction (or query) or the LIMIT+OFFSET keywords. Regards Gilles DAROLD