Subject multiple queries
Author Lester Caine
This is probably a silly question, but I've never had the need to even think
about it.

Can you run multiple queries at the same time on a connection?

The question has come up on discussions on making the PHP PDO library work with
'Asynchronous Requests' and while it's not something I have had to bother with
myself, the reasoning behind it does make sense. If you have some data which
will take a while for the engine to return, a count of records that one can't
engineer out for instance, so one starts that query but then carry on working to
build up the rest of the data with other queries. By the time the rest of the
data has been gathered, the first query may also be finished so the rendering
time for a page is reduced.

I know that this depends on the application end being able to do multiple
things, and I've often run things in parallel in the past in C++ but not in PHP.
But at this stage the question is - can the client interface handle the
situation. I've seen some threads about this in relation to .net and C++
threading needing separate connections, but I need to understand if the basic
link could handle it?

Lester Caine - G8HFL
Contact -
L.S.Caine Electronic Services -
EnquirySolve -
Model Engineers Digital Workshop -
Firebird -