Mysql query limitations

[Anon]

Don't know if I have experienced the limitations of Mysql or not?...

I am simply testing a bulk email script using 3000 email addresses and for each address I am seeing if mysql can handle being queried to get the recipients names....it's just one table that is being queried with fname, lname and email and an index on email.

The script or mysql seems to stop at 350 every time. If I don't have the mysql queries it can do the whole 3000 no probs..

so Does Mysql have any limitations on the amount of queries it can handle?

[Anon]

Never mind....it can't be Mysql, it must be something else that is causing the script to stop.

[Anon]

Your PHP script is most likely timing out... Each server has a different Time limit. You can set the time limit for a PHP script to an unlimited ammount of time using the following command:

set_time_limit(0);

More info here:
http://www.php.net/manual/en/function.set-time-limit.php

-Josh