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

Richard Lynch schreef:

On Fri, January 25, 2008 11:33 am, Floor Terra wrote:

I know how to do multiple queries - the key issue in my question was how to do them concurrently (i.e. in parallel).

So you want to make PHP multithreaded???

No, just the mysql queries.

Try pcntl_fork() to create a child process for each query. Each child can make it's own MySQL connection.

Do *NOT* do this in a web-server environment, unless you have EXTENSIVELY and EXHAUSTIVELY tested all your PHP extensions for thread-safety!

I agree about the don't do that part - but what has process forking got to do with thread safety? AFAIK you shouldn't do that because it madness to fork a complete apache process.

http://php.net/pcntl_fork just plain says "Don't do that." for a reason...