Re: [PHP] Allowing multiple, simultaneous, non-blocking queries.
Richard Quadling wrote: Hi. As I understand things, one of the main issues in the When will PHP grow up thread was the ability to issue multiple queries in parallel via some sort of threading mechanism. Due to the complete overhaul required of the core and extensions to support userland threading, the general consensus was a big fat No!. Maybe a Thanks, but no thanks. As I understand things, it is possible, in userland, to use multiple, non-blocking sockets for file I/O (something I don't seem to be able to achieve on Windows http://bugs.php.net/bug.php?id=47918). Can this process be leveraged to allow for non-blocking queries? Being able to throw out multiple non-blocking queries would allow for the queries in parallel issue. My understanding is that at the base level, all queries are running on a socket in some way, so isn't this facility nearly already there in some way? AFAICT (i.e. without having tried it), myqlnd enables you to do asynchronous queries on mysql - the docuementation is a little lacking. Personally speaking, that would be my first avenue of attack. -- Per Jessen, Zürich (8.2°C) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Allowing multiple, simultaneous, non-blocking queries.
Hi. As I understand things, one of the main issues in the When will PHP grow up thread was the ability to issue multiple queries in parallel via some sort of threading mechanism. Due to the complete overhaul required of the core and extensions to support userland threading, the general consensus was a big fat No!. As I understand things, it is possible, in userland, to use multiple, non-blocking sockets for file I/O (something I don't seem to be able to achieve on Windows http://bugs.php.net/bug.php?id=47918). Can this process be leveraged to allow for non-blocking queries? Being able to throw out multiple non-blocking queries would allow for the queries in parallel issue. My understanding is that at the base level, all queries are running on a socket in some way, so isn't this facility nearly already there in some way? Regards, Richard. -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts-exchange.com/M_248814.html EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498r=213474731 ZOPA : http://uk.zopa.com/member/RQuadling -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Allowing multiple, simultaneous, non-blocking queries.
Hi Richard At the end of discussion, the best bet for something that approaches a threaded version of multiple queries would be something like: 1. open connection to database 2. issue query using asynchronous call (mysql and postgresql support this, haven't checked the others) 3. pick up result when ready To get the threaded-ness, just open a connection per query you want to run asynchronous and pick it up when you're ready for it - i.e. iterate over steps 1-2, then do step 3 when things are ready. Regards Peter On 26 March 2010 12:45, Richard Quadling rquadl...@googlemail.com wrote: Hi. As I understand things, one of the main issues in the When will PHP grow up thread was the ability to issue multiple queries in parallel via some sort of threading mechanism. Due to the complete overhaul required of the core and extensions to support userland threading, the general consensus was a big fat No!. As I understand things, it is possible, in userland, to use multiple, non-blocking sockets for file I/O (something I don't seem to be able to achieve on Windows http://bugs.php.net/bug.php?id=47918). Can this process be leveraged to allow for non-blocking queries? Being able to throw out multiple non-blocking queries would allow for the queries in parallel issue. My understanding is that at the base level, all queries are running on a socket in some way, so isn't this facility nearly already there in some way? Regards, Richard. -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts-exchange.com/M_248814.html EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498r=213474731 ZOPA : http://uk.zopa.com/member/RQuadling -- 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