kristoferbenham Posted June 7, 2010 Posted June 7, 2010 I have GoDaddy for hosting, and I already have a live Zen Cart store in there currently. Zen Cart keeps getting very slow as I get to 20,000 items, and the limit is supposedly in the billions. Because of this, I would like to switch my store to OSCommerce files, but I am not sure what to do WITHOUT losing everything that I have in the database already. The whole point in doing this is for the bulk uploading with Easy Populate. I sell baseball card singles, so the items will eventually get into the millions, if I can find a store that can allow me do do this without slowing down. If GoDaddy is the problem, then I have no idea what to do to use my domain on another hosting provider that has a better server, or whatever may be the problem. Any suggestions and ideas on what I can or should do? Remember, bulk uploading and open source are a MUST, and I can't have the site slow down ever. www.benhambaseballcards.com/shop
Guest Posted June 7, 2010 Posted June 7, 2010 Kristofer, OSC has similar limitations with the base code when you get into that many products. However, there are forums here on how to change the SQL queries to optimize speed of database functions. Your Hosting Provider is not usually the problem, it is the way the code accesses the database. Chris
kristoferbenham Posted June 7, 2010 Author Posted June 7, 2010 My database VARCHAR for the product_name had to be increased to 96, as well as the categories_name. Do you think this may be part, or the majority, of the problem? www.benhambaseballcards.com/shop
Guest Posted June 7, 2010 Posted June 7, 2010 Kristofer, No, that would not cause the slow down. It is in fact the shear number of products and how the database is accessed by the code. If you search this forum, you will find references related to 'speeding up my database' and 'my site is running slow' Chris
kristoferbenham Posted June 7, 2010 Author Posted June 7, 2010 Thanks for comforting me about some of the misleading info that I have been getting. www.benhambaseballcards.com/shop
burt Posted June 8, 2010 Posted June 8, 2010 20000 items is a small shop. That should not be causing such a drastic slowdown. Would suggest you liaise with your host and get them to watch your site for a while to ascertain the nature of the slowdown.
kristoferbenham Posted June 8, 2010 Author Posted June 8, 2010 Now that you mention that, I actually called GoDaddy and my internet provider at separate times to get them to monitor the speeds for each of them. GoDaddy said that there was a tiny slowdown, but that it was getting to be a busy time of day. My ISP told me that there was nothing that they could see that would be causing a slowdown. As far as getting GoDaddy to watch the site for any amount of time, I am sure that they will not spend the time to do so. They already have my money, and I paid more to get their Deluxe hosting package so I wouldn't have problems like this. I really want to change the files to OSCommerce, but I don't want to lose the customer info in my database. I am also not really sure how to add Easy Populate into the mix either. When I did this with Zen, it was all in the same files. I am kinda of just waiting to run into someone near me that knows how to do this stuff well. I will just ask them to help me and hook them up with something for the help. www.benhambaseballcards.com/shop
Recommended Posts
Archived
This topic is now archived and is closed to further replies.