Guest Posted September 7, 2010 Posted September 7, 2010 I am looking to setup a HUGE store of over 600,000 items every item has a unique name every item is the same price every item has NO picture When I have them all in one database the site is a hit or a miss whether it loads or not...... Would it work if I split it into 2 seperate shops (Shop 1 - items 0-300,000) (Shop 2 - items 300,001-600,000) Cheers for any help/advice Michael
burt Posted September 7, 2010 Posted September 7, 2010 600k items is large, but not ooutside the scope of osCommerce. One of my old clients has millions of items in a setup similar to yours - no images. I coded it to have the image created for each product on the fly, taken from a standard background onto which text is placed. What you need to do is strip osCommerce of everything that is un-needed. Then optimise the SQL queries used (tax is one that is a biggy). Then optimise your server to handle it. I'm hoping that you are not attempting this on a shared webhost and that you have your own webserver specifically for this.
Guest Posted September 7, 2010 Posted September 7, 2010 600k items is large, but not ooutside the scope of osCommerce. One of my old clients has millions of items in a setup similar to yours - no images. I coded it to have the image created for each product on the fly, taken from a standard background onto which text is placed. What you need to do is strip osCommerce of everything that is un-needed. Then optimise the SQL queries used (tax is one that is a biggy). Then optimise your server to handle it. I'm hoping that you are not attempting this on a shared webhost and that you have your own webserver specifically for this. Cheers for the info.....I'm on shared webhosting unfortunately .... I didn't really think I'd have to go down the dedicated route for my little project. but I will do a search on optimising SQL queries
♥FWR Media Posted September 7, 2010 Posted September 7, 2010 Splitting the shop shouldn't be necessary but a lot of attention will have to be applied to the queries, caching, avoidance of complex joins and table scans. I imagine that split page results would be a bottleneck. You don't mention the number of categories. You replied while I was posting. I doubt there is any chance at all of running a shop of this size on shared hosting. Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.