Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Too Much Time To Load The Sales Reports ! Any Help Rate Topic   - - - - -

 
  • majed
  • Junior Member
  • Members
  • Join Date: 22-Aug 10
  • 30 posts

Posted 16 June 2015 - 07:55 AM #1

Hi all we are a non profit site with 240 projects for now
every thing is moving smooth in our site even after upgrading the version to V4

one thing is the time when i ask for any Sales report is too much and slow until it is back with the results
it takes about 1 min to show the last year report orders which they are 67698 order

so is this is normal due to the big number of orders or u think there is something we can do to fix this issue

note that when just click the view orders button to see the orders within any period of time it takes 3 seconds to view all the results

any help is appreciated

direct-aid.org/donate/en

 
  • Alt-team
  • CS-Cart Developer
  • Authorized Reseller
  • Join Date: 18-Jan 11
  • 2688 posts

Posted 16 June 2015 - 08:21 AM #2

Assalamu alaikum,

A request is simple on the manage orders page. On the sales reports page, the request is more difficult and probably he runs long.

Try to examine mysql long queries log. Maybe need to add some indexes to database tables.

Thank you.

ADD-ONS  Web development service  | CS-Cart dedicated developers

Buy MULTIVENDOR - USD 1250 (14% off)   Buy CS-CART LICENCE - USD 345 (13% off)

 Email - manager@alt-team.com | Skype - Altteam    


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19844 posts

Posted 16 June 2015 - 08:42 AM #3

It is hard to say anything, examination is required. Try to contact CS-Cart support team or hire someone from this forum

GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.