jbwax Posted June 16, 2006 Share Posted June 16, 2006 This error message shows up each time anyone tries to get on our site: 1226 - User 'scrapbo1_p_os1' has exceeded the 'max_questions' resource (current value: 50000) select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP] 'scrapbo_p_os1' is the name of the database. Do I need to add a second database? How would that be done if need be? Or am I way off the problem? Thanks Jay Link to comment Share on other sites More sharing options...
choosealogin Posted June 16, 2006 Share Posted June 16, 2006 I'm not an expert on this subject, and I think you already know the general problem (too many database queries) ... All kinds of things play a part in that...and I as I understand it 50,000 may not really be your limit, but a limit you share with others. I could be wrong on that though. Do you have "show category counts" turned on? Turning that off will reduce the number of queries considerably, especially if you have a lot of products/categories. There are a lot of threads here somewhere re. optimization of the db...here's one: http://www.oscommerce.com/forums/index.php?showtopic=119077 Link to comment Share on other sites More sharing options...
jbwax Posted June 16, 2006 Author Share Posted June 16, 2006 Thanks for pointing me in the right direction! Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.