roberttran Posted November 17, 2002 Posted November 17, 2002 I have noticed that when ever someone creates an account, processes an order, or update and order status, it takes a really long time. Could this be a problem with the database? I also still have a problem with orders not showing up in the orders list. I do not think it has to do with a paypal thing, because I am still receiving some paypal orders. Could this be related to the database?
Guest Posted November 17, 2002 Posted November 17, 2002 I have noticed that when ever someone creates an account, processes an order, or update and order status, it takes a really long time. Could this be a problem with the database?I also still have a problem with orders not showing up in the orders list. I do not think it has to do with a paypal thing, because I am still receiving some paypal orders. Could this be related to the database? Robert, I went through this for 2 weeks and finally sat down and checked the calls to the databse and index'd thos fields.. Now the database is like lighting kmcar :D
Criados Posted November 17, 2002 Posted November 17, 2002 I went through this for 2 weeks and finally sat down and checked the calls to the databse and index'd thos fields.. Now the database is like lighting kmcar :D Hmm, any chance of letting us know the indexes you are using?
Guest Posted November 18, 2002 Posted November 18, 2002 How easy would it be to index my databse thru phpMyAdmin? Indexing is a new concept to me. I'm still under development for my store, but once its up and going it should have 4000+ items. I don't want the database to be slugish then, or now. So should I index the database now? OR do it later? How would I go about doing this? Thank you!
Guest Posted November 18, 2002 Posted November 18, 2002 How easy would it be to index my databse thru phpMyAdmin? Indexing is a new concept to me. I'm still under development for my store, but once its up and going it should have 4000+ items. I don't want the database to be slugish then, or now. So should I index the database now? OR do it later? How would I go about doing this? Thank you! Aure .. I will make a list today of the indexes and post. Give me a hour or so kmcar :D
Guest Posted November 18, 2002 Posted November 18, 2002 How easy would it be to index my databse thru phpMyAdmin? Indexing is a new concept to me. I'm still under development for my store, but once its up and going it should have 4000+ items. I don't want the database to be slugish then, or now. So should I index the database now? OR do it later? How would I go about doing this? Thank you! Here ya go http://www.oscommerce.com/downloads.php/co...ions,684/type,5
Guest Posted November 18, 2002 Posted November 18, 2002 which snapshot are you using? That one is Ian's Loaded Snapshot August
Guest Posted November 18, 2002 Posted November 18, 2002 Thank you very much!! I'm using Ians Load_3 snap shot. I have also added a few mods to the store, plus done some other modifications to it. But the core is Ians loaded3 snapshot. Thank you!!
roberttran Posted November 21, 2002 Author Posted November 21, 2002 I just put indexes in my database and they still seem slow. It is only slow when I create or change something
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.