mr.e-man Posted December 1, 2005 Share Posted December 1, 2005 I know this is kind of an open ended question, because there are so many variables, but I'm wondering what the store capacity is with a 100MB mySQL database. I'd like to know things like approximately how many items, users, etc. Even just feedback from user experience would be great. I'm new to osCommerce, but I really like what I see so far. Thanks for all of your input. Link to comment Share on other sites More sharing options...
mr.e-man Posted December 1, 2005 Author Share Posted December 1, 2005 BUMP ... Is this a stupid question? Is that why nobody's replying? Link to comment Share on other sites More sharing options...
kwalker Posted December 1, 2005 Share Posted December 1, 2005 Your 100M database should run without any problems. One of mine is approximately that size and I have no problems. Not sure of the exact limit, but I know your database size is no problem. Kevin. "What I didn't know yesterday, I know today & will remember tomorrow" (By Kwalker) What do you see when you open up the tep_database-pr2.2-CVS.pdf file that came with your osCommerce download? Link to comment Share on other sites More sharing options...
mr.e-man Posted December 1, 2005 Author Share Posted December 1, 2005 Your 100M database should run without any problems. One of mine is approximately that size and I have no problems. Not sure of the exact limit, but I know your database size is no problem. Kevin. That's what I'm talking about ... a reply!! Thanks for the info kwalker. Just curious, how many items do you have in your store? I'm figuring that since the DB is only storing text and not images, you should be able to cram quite a bit in to 100MB. Muchas gracias!! Link to comment Share on other sites More sharing options...
kwalker Posted December 1, 2005 Share Posted December 1, 2005 One of my sites have a few thousand products. That's nothing. I've read somewhere while learning .php that there are databases that have millions of records. And they run fine. Imagine that! Kevin "What I didn't know yesterday, I know today & will remember tomorrow" (By Kwalker) What do you see when you open up the tep_database-pr2.2-CVS.pdf file that came with your osCommerce download? Link to comment Share on other sites More sharing options...
Cheepnis Posted November 7, 2006 Share Posted November 7, 2006 I have nearly a thousand products and my DB is 21Mb. Cheers, Michael www.mst3k.org Link to comment Share on other sites More sharing options...
Guest Posted November 7, 2006 Share Posted November 7, 2006 One of my sites have a few thousand products. That's nothing. I've read somewhere while learning .php that there are databases that have millions of records. And they run fine. Imagine that!Kevin <Off topic> On a mysql server that I managed before we had a database with more than 300 000 000 (three hundred million) posts, it was ~145Gb. Last I heard it had more than 550 000 000 posts and was 190Gb+ REPAIR TABLE was not fun on that one, took 15hours+ Since it was a production database that needed to be up 24/7 that was not a fun thing to do. </Off topic> A little more on topic, on one of my testsites for oscommerce I have ~3000 orders and ~1900 customers and ~400 products. That database is ~4.5Mb. So I dont think that you have to worry about running out of db-space Link to comment Share on other sites More sharing options...
Jack_mcs Posted November 7, 2006 Share Posted November 7, 2006 There's is no easy answer to your question since it depends on things like how large your images are, how long your product description are and how many emails you store on the server. An oscommerce shop takes less than 10 MB to run, to give you a starting point. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
angelkelly Posted May 13, 2007 Share Posted May 13, 2007 My store has around 2000 products in (with 2 images per product and about 7 contributions added). Its currently around 27mb, although this includes excess pictures and 'baggage' that I havent taken out yet. So a 100mb store will easily hold 8000 to 10,000 products without a problem. The best thing to do is to go with a host who lets you upgrade your package and mb size when your store reaches the limit. I just upgrade to the next level, without interruption to my store. 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.