Re: how dod you get to do multiple mysql queries concurrently?

From: Date: Sat, 26 Jan 2008 09:28:45 +0000
Subject: Re: how dod you get to do multiple mysql queries concurrently?
References: 1 2 3  Groups: php.general 
Request: Send a blank email to php-general+get-268151@lists.php.net to get a copy of this message
I posted you a short script on this thread at 04:07 GMT today that'll get you multithreading (via cli) - but even then you can shell exec that cli script from apache.. Per Jessen wrote:
Richard Lynch wrote:
On Fri, January 25, 2008 3:35 am, Per Jessen wrote:
I have a website where some of the pages require several mysql queries - they're independent, so in principle they could easily be run in parallel. Has anyone looked at doing that?
If MySQL has implemented "cursors" in some new version, you have just described a "cursor"... There may be something else in MySQL to do this, mind you, but that's the easiest way I know of in other DBs...
cursors exist in mysql too, but I don't quite see how I could use them to run two queries concurrently? Also, these queries don't return a lot of data. /Per Jessen, Zürich


« previous php.general (#268151) next »