Re: Re: how dod you get to do multiple mysql queries concurrently?
| From: | Floor Terra | Date: | Fri, 25 Jan 2008 17:53:35 +0000 |
| Subject: | Re: Re: how dod you get to do multiple mysql queries concurrently? | ||
| References: | 1 2 3 4 5 6 7 8 9 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-268113@lists.php.net to get a copy of this message | ||
On Jan 25, 2008 7:42 PM, Per Jessen <per@computer.org> wrote:
>
> > Try pcntl_fork() to create a child process for each query.
> > Each child can make it's own MySQL connection.
>
> Hmm, interesting idea. I wonder if that'll work under apache?
>
You have to compile with --enable-pcntl to use it.
P.S.
If your queries take >30 second to complete I would suggest
you do some sql optimizations or try to cache as much data
as possible.