Very slow listing of orders

Store Builder Questions
1

Hi,



Since quite some time now our admin is very slow in listing all the orders. We have about 3000 orders and it takes up to several minuted to show the orders.manage listing after a new order was placed or a order status changed. I thinks its a smarty thing, because when no changes have been made its fast as normal.



Any ideas where to start looking?



Still using 2.1.4 btw

2

Hello,



Well you should sure ask the tech support about this issue.

You should create a ticket in your HelpDesk account and you'll get help shortly.

3

so i'm really the only one experiencing this?



i've created a helpdesk ticket, but i dont mind solving it myself, as long as i know where to look into

4

Got this response of the CS-Cart team:



Also we advise you to make a backup of your database (in order that you could restore your database if you have a problem) on the Database page in your store administration panel. A link to this page is in the Administration drop-down menu. Then upload and restore the attached SQL file in the Restore tab on the same page. I hope it will help you.



attached SQL:

ALTER TABLE forward_version214.cscart_order_docs ADD INDEX type ( order_id , type );



and this seems to have fixed my problem :)

its faaaaaast again



wooohooo

5

I'm using version 2.2.5 and facing the same problem. Contacted CS cart team and they told me that its a problem at my server end? strange!!!

6

[quote name='shoppingmantra' timestamp='1355474123' post='151148']

I'm using version 2.2.5 and facing the same problem. Contacted CS cart team and they told me that its a problem at my server end? strange!!!

[/quote]

Did you follow the guidance provided by Youlikeit? Remember to do a backup of the database before running any SQL commands on the database.