ekv Posted June 25, 2007 Share Posted June 25, 2007 I work at a hosting provider with a number of OSCommerce sites, some on shared hosting, some on dedicated. We have one customer who is starting to experience the crunch of existing in a shared environment. To further complicate things, they want to expand their inventory. Currently, they have about 65,000 items, and are looking to move that up to 150,000. The mitigating factor is that it's all text listings, no graphics. Does anyone have any recommendations for hardware for a very large site (at least in my opinion), or previous experience using OSCommerce for hundreds of thousands of entries? Are there any bottlenecks or scaling issues to be aware of? Sincere thanks for any advice. Link to comment Share on other sites More sharing options...
mjm Posted June 25, 2007 Share Posted June 25, 2007 First and foremost, modify the base code to be nice to your database server(s). One of the worst queries is within the 'Also Purchased' section of the individual product pages, modify that to only look at the last XX orders or your machine is gonna die pretty quick. There are some really nice caching contributions you can install to make everything run very smoothly on a rather small machine. I have 1 account on a dedicated system, they don't have too many products (perhaps 1000?), but they do push at least 70 orders a day. Tons of entries into their orders table. Dell 1U Something or other CentOS 4X 2.6Ghz P4 512MB Memory 1GB Swap (never hit it) 73GB Disk If I was running the store you're talking about; I'd use a machine similiar to that with 2GB of memory and cleaned up OSC codebase. 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.