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

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

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: 38

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,244

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: 38

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,244

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