Re: [PDO] Asynchronous requests

Yes ... forgot to change the address ;)

Lukas Kahwe Smith wrote:
> 
> On 03.11.2009, at 15:06, Lester Caine wrote:
> 
>> So what is asyncQuery() ... if it's a query in a new transaction 
>> space, then it just needs a separate connection to use it. If it's 
>> simply processing the data records as they arrive rather than waiting 
>> for the complete result set, then that is how *I* normally work anyway.
> 
> the idea is to send of a bunch of queries and then poll so that you can 
> get to work as soon as any of those queries is able to provide data. so 
> you are not longer sequentially working through your queries:
> http://blog.ulf-wendel.de/?p=170
> 
> Not sure if postgresql's approach is the same (it seems more like multi 
> query .. as in sending multiple queries at once and then working through 
> them sequentially, but maybe combined with postgresql's notify support 
> it can be used for parallel out of order handling).

Well a quick review of that would seem to say that this is nothing to do
with the MySQL, but rather a means of running multiple queries in
parallel ... As I said first off ... it just needs a separate connection
for each query, so I don't see anything that would preclude it being
implemented in PDO RATHER than in just in pdo_mysql?

I can see major problems with running multiple connections and
maintaining transaction integrity - but firebird already has a method of
handling cross connection commits. Not sure that other databases will be
capable of the same integrity ;)

The obvious question here is - why is the mysql driver having all this
effort spent on it rather than implementing it directly in PDO?

-- 
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php