On 25 March 2010 22:51, Lester Caine <lester@xxxxxxxxxxx> wrote: > Per Jessen wrote: >> >> Tommy Pham wrote: >> >>> I'm presenting the argument for threading. Per is presenting the work >>> around using asynchronous queries via mysqlnd. I did read that link a >>> few days ago, "Although the user can send multiple queries at once, >>> multiple queries cannot be sent over a busy connection. If a query is >>> sent while the connection is busy, it waits until the last query is >>> finished and discards all its results." Which sounds like threads -> >>> multiple connections to not run into that problem. >> >> You must have read the wrong page. This is NOT about multiple queries, >> it's about _asynchronous_ queries. > > The only problem here is what the database client can handle. If it can only > handle one active query, then that is all that can be used. It can be > started asynchronously and then you come back to pick up the results later, > and so you can be formating the page ready to insert the results. PDO > requires that you start a different connection in a different transaction > for each of these queries, but that is another hot potato. Running 10 > asynchronous queries would require 10 connections as that is how the > database end works. Adding threading to PHP is going to make no difference? Actually, this sounds very close to having 10 threads each opening a connection to the database and running the query ... which was the solution to the scenario presented, if memory serves. > -- > 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 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- <hype> WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind Flickr: http://www.flickr.com/photos/fake51 BeWelcome: Fake51 Couchsurfing: Fake51 </hype> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
