I seem to be running into some sort of MySQL query limit, is there anything that can be done?
Some hosts setup a query limit on your MySQL database. This is usually a per hour limit and would be restored in time. Floridave believes that a reasonable value for this would be 50-70k, but some hosts might set it as low as 10k. See if your host will bump it up a little bit perhaps. A workaround is to create several users of the database and randomly use those users to connect: • http://gallery.menalto.
Related Questions
- Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?
- I seem to be running into some sort of MySQL query limit, is there anything that can be done?
- Can I limit the number of rows returned by a query using the ICOBOL ODBC driver?