How many Records Can SQL Hold
11 posts by 6 authors in: Forums > CMS Builder
Last Post: April 12, 2011 (RSS)
By jenolan - April 12, 2011
Depending on your server hosting company they may be putting time out or additional memory restrictions on the mysql daemon.
One thing you might check is that the SQL you are using is accessing the mysql table using an index this is the most common cause of excess usage, if every request you make is causing the entire table to be transversed it could be enough to cause a resource problem even though you are only actually pulling a few records.
Larry
One thing you might check is that the SQL you are using is accessing the mysql table using an index this is the most common cause of excess usage, if every request you make is causing the entire table to be transversed it could be enough to cause a resource problem even though you are only actually pulling a few records.
Larry
---
Peace and Long Life
Peace and Long Life