martyjoe Posted July 11, 2003 Share Posted July 11, 2003 i just loaded 20'000 + item into store db. slow as syrup, even slower. mysql using 164% of cpu. have dual drive w/ over 700+ ram. have mysql 3.25. any idea of steps i should take? :cry: marty hafner Link to comment Share on other sites More sharing options...
241comp Posted July 11, 2003 Share Posted July 11, 2003 First, turn off the product counts for categories - that is a MAJOR problem with lots of products. Second, download MySQL 4.0.13 and turn on query caching. It makes a huge difference. Third, ensure that cache is enabled on the site (in the admin section). Do those and report back about your success. Also, you may want to PM or email the URL to people who are trying to help so we can see what the store is doing. Let me know how it goes. Link to comment Share on other sites More sharing options...
martyjoe Posted July 11, 2003 Author Share Posted July 11, 2003 thank you marty hafner 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.