Re: DBD::Pg 2.0.0 release candidate available for testing

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