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

From: Date: Sat, 26 Jan 2008 09:45:05 +0000
Subject: Re: how dod you get to do multiple mysql queries concurrently?
References: 1 2 3 4  Groups: php.general 
Request: Send a blank email to php-general+get-268153@lists.php.net to get a copy of this message
Nathan Rixham wrote: > 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.. Yeah, I noticed, thanks. The thing is - once pcntl_fork() is added to the mix, it's getting a little too complicated for what was otherwise a simple php web-application. I'm thinking I'm probably better off with my iframe-rpc stuff. >Back on the mysql side of things, try using geometry columns rather >than numerical primary keys, with spatial indexes.. it's a MASSIVE >performance upgrade (I've cut 5 second queries down to 0.005 by using >geo columns) Uh, could you could elaborate a bit on that (whilst I go and do some googling)? /Per Jessen, Zürich

« previous php.general (#268153) next »