query without waiting for return

[groovepapa]

I'm running a batch of fairly lengthy RESTORE TABLE statements via a PHP script to a MySQL database.

I'm wondering if there's a way I can run mysql_query() and not have to wait for each statement to finish before going onto the next one. so, I'd like to be able to send the RESTORE TABLE statements off to MySQL and let it be doing as many of those simultaneously as possible.

we've got quad-processor boxes on the servers and they barely get used when the restores run one at a time.

thanks,
-L

[jovanross]

Try this:
http://us2.php.net/manual/en/function.mysql-unbuffered-query.php

[groovepapa]

oh yeah...I had looked that up before and forgot. thanks. I'll see if it will do what I'm after.