FrontAccounting forum — Facing slow downs with Direct Invoice page took ~6.66s with large DB

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

null@example.com (apmuthu) — Sun, 24 Aug 2025 18:00:35 +0000

Stop nginx.
Export DB into SQL format as backup.
Rename the database.
Create a new database with the backup on the original db name.
Start nginx.
Check if the problem exists.

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

null@example.com (DrCard) — Sun, 24 Aug 2025 15:40:44 +0000

@apmuthu

So how can this be optimized?

now my database contain more data and it is slower it takes 9s at first load of the page and 3s at second.

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

null@example.com (apmuthu) — Sat, 23 Aug 2025 19:10:13 +0000

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.

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

null@example.com (DrCard) — Sat, 23 Aug 2025 10:33:15 +0000

@apmuthu

Did you have any chance to check.

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

null@example.com (DrCard) — Mon, 18 Aug 2025 08:25:50 +0000

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

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

null@example.com (apmuthu) — Sat, 16 Aug 2025 15:33:21 +0000

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.

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

null@example.com (DrCard) — Sat, 16 Aug 2025 11:21:23 +0000

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