1 Topic by DrCard (edited by DrCard 08/18/2025 08:31:34 am)

  • From: Bahrain, Manama
  • Registered: 12/24/2019
  • Posts: 44

Topic: Facing slow downs with Direct Invoice page took ~6.66s with large DB

Hi,

I'm facing slowdowns with the Direct Invoice page it might be because my database contain a lot of customers and dimensions so how can we improved to be faster.

When I open it first time after I logged in it took ~6.66s but when my session is still active and not logged out and I visit the page again it took ~1.32s.

P.S. sample database sent to @apmuthu for debugging purposes

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,266

Re: Facing slow downs with Direct Invoice page took ~6.66s with large DB

Just tested it out. Yes the first Direct Invoice page is slow or even times out. Logged out, cleared cache and closed browser. On next login everything is fine. Looks like some server startup / mysql index recreation / updation issue. Not to worry.

apmuthu's Website

3 Reply by DrCard (edited by DrCard 08/18/2025 03:04:11 pm)

  • From: Bahrain, Manama
  • Registered: 12/24/2019
  • Posts: 44

Re: Facing slow downs with Direct Invoice page took ~6.66s with large DB

Does doesn't solve the issue

see it live with this video

https://limewire.com/d/8sVmD#7dwHq2I31A

it takes 6.66s

BTW we are using nginx

  • From: Bahrain, Manama
  • Registered: 12/24/2019
  • Posts: 44

Re: Facing slow downs with Direct Invoice page took ~6.66s with large DB

@apmuthu

Did you have any chance to check.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,266

Re: Facing slow downs with Direct Invoice page took ~6.66s with large DB

I checked on Apache 2.2.
Check the cache folder permissions if using caching. Looks like it is not allowing to store cache of php pages.
Also check the tmp/errors.log
Investigate with go_debug settings in config.php
See if the includes/session.inc file setting for secure constants need changing.
Your data on Debian 6 based FA system seems working fine after first callup.

apmuthu's Website