Re: [PDO] Asynchronous requests

Lukas Kahwe Smith wrote:
> Ahoi,
> 
> I added some more topics of concern to the wiki like the previously discussed issues of features that are only relevant to one or few drivers or that cannot be unified. I have also added a note about different error handling issues. Finally I also added the recently noted differences in handling of using the same placeholder name multiple times as well as issues with the simplistic prepared statement parser/rewriter.
> 
> I guess we already have a fair bit of stuff on that page, but I think we probably need to brainstorm a bit longer before we are ready to move on the next steps (like working through all the notes and making a more coherent document out of the notes and then pondering about future development).

Lukas - as ever time prevents a full investigation, but it DOES seem to me that 
Asynchronous requests does not actually rely on anything in the database driver. 
It is simply a php end invention that could potentially be used with any driver?

I simply don't have time to go any further into the MySQL implementation of it 
since it's well out of my 'comfort zone', but it does seem a perfect candidate 
for PDO ? And would potential remove the need for a driver specific version?

I still have the outstanding question regarding 'multiple transactions' and if 
this will ever be possible with the current PDO base structure.
http://uk3.php.net/manual/en/function.ibase-trans.php supports 'transactions 
over multiple database connections' and 2 phase commit's across databases. Being 
able to simply set up a second transaction on the existing connection can be 
handled by creating a new PDO object, although I don't see the reason for 
duplicating the base connection object, but linking connections into the one 
transaction would not seem to be be possible at all?
I suppose that this does link up with the possibility of using an existing 
native driver connection?

-- 
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