Magento Expert Forum - Improve your Magento experience
Magento invoice section - VERY SLOW - HELP
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 ?
View more threads in the same category:
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.
thanks for help,
Originally Posted by david
i will try to do this and i will get back to you
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?
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...