Re: how dod you get to do multiple mysql queries concurrently?
| From: | Richard Lynch | Date: | Fri, 25 Jan 2008 18:20:06 +0000 |
| Subject: | Re: how dod you get to do multiple mysql queries concurrently? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-268118@lists.php.net to get a copy of this message | ||
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...
I suppose you could try with a shell script and pipes and files and
using "&" with exec() but any savings from MySQL would probably be
dwarfed by the exec() call...
Are the queries actually SLOW and killing your site, or are you just
performance-wanking?
--
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/from/lynch
Yeah, I get a buck. So?