cherubrock74 Posted January 14, 2007 Share Posted January 14, 2007 Maybe this will sound like a stupid question...but is there a limit to the number of products in a oscommerce powered estore? Does it depends from the size of the mysql database? I have 100MB database...would it handle thousands of produts? what really creates the size that fills the database space? again sorry for the stupid questions thank you Link to comment Share on other sites More sharing options...
wheeloftime Posted January 14, 2007 Share Posted January 14, 2007 Maybe this will sound like a stupid question...but is there a limit to the number of products in a oscommerce powered estore?Does it depends from the size of the mysql database? I have 100MB database...would it handle thousands of produts? what really creates the size that fills the database space? again sorry for the stupid questions thank you The limit is your space and with 100 Mb. you can have indeed thousands of products in your database unless you have an essay of many pages for every product. A lot of orders with much text will add up also during time but with keeping your Db cleaned up you should not have to worry. Link to comment Share on other sites More sharing options...
cherubrock74 Posted January 14, 2007 Author Share Posted January 14, 2007 The limit is your space and with 100 Mb. you can have indeed thousands of products in your database unless you have an essay of many pages for every product. A lot of orders with much text will add up also during time but with keeping your Db cleaned up you should not have to worry. Hi and thanks a lot for your reply How do you keep the database clean? Is there a specific maintenance that I need to do once in a while? How do you perform this kind of maintenance on a mysql database? This is my first time trying to build up a e-store... can you point me to the most important factors I should take into consideration when opening an e-store? if you have time please let me know thank you Link to comment Share on other sites More sharing options...
wheeloftime Posted January 14, 2007 Share Posted January 14, 2007 Hi and thanks a lot for your replyHow do you keep the database clean? Is there a specific maintenance that I need to do once in a while? How do you perform this kind of maintenance on a mysql database? This is my first time trying to build up a e-store... can you point me to the most important factors I should take into consideration when opening an e-store? if you have time please let me know thank you With phpMyAdmin you have a tool to optimize your tables, amongst other maintenance options, once and a while as there will be a growing overhead on them when adding/deleting information etc. There is so much about e-stores it would be beyond this thread to start telling about it. Browse and search the forum for lot's of information and different opions about several aspects. Link to comment Share on other sites More sharing options...
videobus Posted January 14, 2007 Share Posted January 14, 2007 I haved a client who is a video store and has over 45k items in MySQL database. No issues at all. They are categorized in about 20 groups (action, adventure, children, etc.) One of the mods I made is to store the images in individual category folder, rather than have 45k images in the image folder. Eg: \image\action\ \image\adventure\ \image\children\ Makes it easier to track product images 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.