Magento invoice section - VERY SLOW - HELP

Hello,

We are recently expiriencing very SLOW responde from our MAGENTO STORE in the INVOICE – section. Browsing through the invoices is becoming really pain and timewaste it usualy takes about 15 seconds until the window opens and shows the INVOICES...

We have about 7k + invoices in the base and we think that its because of our big base the responde is slow…

Thats why we are wondering does anyone have any modules – extensions writen to archive INVOICES ore have any solution on how to speed up ore fix this issue ?

We have found alot of extensions out on the internet to archive ORDERS but that is not going to help us we need to archive the INVOICES !

Can somebody help us out ?

Regards

If you has not ever clean database log then I am pretty sure it is a huge number now. Let 's try to clean your database log with this instruction http://magento2x.com/optimize-magent...-cleaning-log/

Then if it 's still slow, please tell me.

I think speed2x is right. This problem happen almost because of the huge database log. Let 's clean it up but remember backup the database first.

Quote:

---

Originally Posted by david

I think speed2x is right. This problem happen almost because of the huge database log. Let 's clean it up but remember backup the database first.

---

thanks for help,

i will try to do this and i will get back to you

Quote:

---

Originally Posted by Jolies453

thanks for help,

i will try to do this and i will get back to you

---

Attachment 127

i already have in settings that the logs are cleaned each day so i dont think this is the problem ?

what other options do i have left ?

we have tryed to clean the LOGS on MAGENTO with the steps you have provided but unfortunately this did not improve the speed of the INVOICES section at all :(

any other ideas on how to improve this ?

Could you try to look at the number of record of table url_log ? And tell me the current number of records?

the number is 459594

we have cleaned the logs again and now we have number 76 but the invoices are still working slowly as before...

my VPS provider also upgraded my RAM from 4 GB to 8 GB and 2 cpu to 4 cpus but this invoices section is still very very slow ....

so this problem is not because of low specs of my VPS problem must be somewhere else...