Magento Expert Forum - Improve your Magento experience

Results 1 to 9 of 9

Magento invoice section - VERY SLOW - HELP

  1. #1
    New member
    Join Date
    Jan 2014
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Arrow 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

    View more threads in the same category:


  2. #2
    Moderator speed2x's Avatar
    Join Date
    Mar 2013
    Location
    Hollywood, Florida, United States
    Posts
    91
    Thanks
    9
    Thanked 7 Times in 6 Posts

    Default

    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.

  3. #3
    Administrator david's Avatar
    Join Date
    Nov 2012
    Posts
    260
    Thanks
    23
    Thanked 40 Times in 33 Posts

    Default

    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.

  4. #4
    New member
    Join Date
    Jan 2014
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Talking

    Quote Originally Posted by david View Post
    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

  5. #5
    New member
    Join Date
    Jan 2014
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lightbulb

    Quote Originally Posted by Jolies453 View Post
    thanks for help,

    i will try to do this and i will get back to you
    Name:  2014-01-06 09_25_08-Konfiguracija _ Sistem _ Trgovina Admin.jpg
Views: 67
Size:  74.1 KB

    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 ?

  6. #6
    New member
    Join Date
    Jan 2014
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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 ?

  7. #7
    Administrator david's Avatar
    Join Date
    Nov 2012
    Posts
    260
    Thanks
    23
    Thanked 40 Times in 33 Posts

    Default

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

  8. #8
    New member
    Join Date
    Jan 2014
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    the number is 459594

  9. #9
    New member
    Join Date
    Jan 2014
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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...

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •