1 Topic by DrCard (edited by DrCard 06/19/2025 08:14:57 am)

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

Topic: GL Inquiry can't show one year of data

When I try query one year using the gl inquiry in my database using one of my accounts which have ~16000 transaction in 2024 the page stuck like what shown in the picture at the attachment and no result given.

How can I let FA give me the result I'm running FA in server with 8GB of ram using RHEL 9 based distro using nginx and php 8.3.

Post's attachments

mkf.png 45.6 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

2 Reply by DrCard (edited by DrCard 06/19/2025 08:16:12 am)

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

Re: GL Inquiry can't show one year of data

Can pagination be implemented with this page?

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

Re: GL Inquiry can't show one year of data

Increase the number of max_input_vars in the php.ini apart from max memory size.

apmuthu's Website

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

Re: GL Inquiry can't show one year of data

I tried to increase the limits as you said and even set the memory limit to something big such as memory_limit = 4G or 6G which I think is way too much what if there is page leaking it might hang my server.

Anyway after increasing the limit I got 10 month to work by 11+ months doesn't work.

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

Re: GL Inquiry can't show one year of data

Restart webserver if php.ini settings were changed.
Optimise your database and introduce some indexes for certain fields used in the report query.
export out your database and recreate it by importing it into a new structure.

apmuthu's Website

6 Reply by DrCard (edited by DrCard 08/03/2025 09:33:42 am)

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

Re: GL Inquiry can't show one year of data

I have a testing server that I can give you access in and you can see and debug the problem could you message me in private to see the issue as the problem is still and not fixed by the configuration that you give me and this face any frontaccounting installation with big data.

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

Re: GL Inquiry can't show one year of data

A lack of indices on some fields of some tables - that only speeds up processing.
If the output is because of having a single output buffer for a very large amount of data that needs to be streamed, then a file capture of the output can be implemented. @joe: any ideas?

Are you using any extensions?
Just take a full compressed backup (delete the data from the users table in the backup) from within FA and upload it somewhere and send me a PM and indicate it here.
What versions of PHP / MySQL are you using?

apmuthu's Website

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

Re: GL Inquiry can't show one year of data

@apmuthu

I sent you a database backup as requested in PM.

We only use SimpleAPI extension.