mltgroup Posted June 13, 2005 Posted June 13, 2005 Hi, I'm not sure what the requirements are for this, (server side vs. software side), but can an OSC store support 2-3 million part numbers in a single store? Thanks.
wizardsandwars Posted June 13, 2005 Posted June 13, 2005 Hi, I'm not sure what the requirements are for this, (server side vs. software side), but can an OSC store support 2-3 million part numbers in a single store? Thanks. <{POST_SNAPBACK}> That's going to be a little heavy for MySQL to handle, and with the way OSCommerce is written, with WAY too many database queries on each page, specifically looking at products and the products table, I'd say probably not. For that much data, you're going to need a more robust DBMS, like Sybase, MS-SQL Server, DB2, or even Oracle. And unfortunatly, OSCommerce currently does not employ a very good database abstraction layer, so it wouldn't be easy to get it to work with a differnet DBMS. All that being said, I'm sure you can probalby get it to work, with a number of db optimizations (indexes), greatly reducing the number of queries on each page (perhaps even using page or query cacheing, or both). I hope you have a dedicated server for your datbase though. With that much data, you'll probably need it. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.
mltgroup Posted June 13, 2005 Author Posted June 13, 2005 Thanks wizardsandwars I appreciate your well explained reply
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.