hoeksms Posted June 29, 2009 Share Posted June 29, 2009 We have developed several oscCommerce shops (2.2rc1) which are hosted on several different webservers. None of these shops have any performance issues, except for one. We have one oscommerce shop which has 100.000+ products in the database. We have already moved it from a shared hosting server to a dedicated server, but a few times a day the load goes up and apache crashes. We have already moved 'products_viewed' and 'products_ordered' from the products/products_description tables to a seperate table, so that the product listing queries are cached by mysql. This has made the product listing a bit faster, but the problem persists. On average we have 50-150 users online. Does anyone have any experience on oscommerce with a large database? Any ideas? Kind regards, S. Hoeksma Link to comment Share on other sites More sharing options...
germ Posted June 29, 2009 Share Posted June 29, 2009 You might find some tips here If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there > 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.