On Jan 23, 2008 2:17 AM, Kaare Rasmussen <[EMAIL PROTECTED]> wrote: > > * Asynchronous queries, which let's you start a query, go off and do > > other things, and check back to see if it has finished, and fetch the > > data when you are ready to. This also allows you to cancel running > queries. > > Can you have more than one async query at any time? I ask because I notice > that pg_ready and pg_result are DB handle methods.
I think you could have more than one async query at a time per Perl script, but not per DB handle. The reason is that libpq only allows one query per database connection, which is because each connection goes to a forked single-threaded backend process. Best Wishes, Chris Travers
