FrontAccounting forum — Ajax Time Out in GL Inquiry

Re: Ajax Time Out in GL Inquiry

null@example.com (boxygen) — Sun, 05 Aug 2018 04:27:38 +0000

I wrote a function to write to a file the sql output for debugging purpose. I forgot to comment that out. That was actually taking too long.

Re: Ajax Time Out in GL Inquiry

null@example.com (kvvaradha) — Sun, 05 Aug 2018 04:24:48 +0000

boxygen wrote:

@kvvaradha, you are right. Thanks alot
I got the problem. One of my customization was basically causing the issue. I must have checked that without customized code.
Regards.

Glad to hear that you found actual reason for the issue. Can you share the details of it?

and it might helpful to someone else knocks with similar issue in future.

Re: Ajax Time Out in GL Inquiry

null@example.com (kvvaradha) — Sun, 05 Aug 2018 04:23:26 +0000

poncho1234 wrote:

@kvvaradha whats a lac? Do you mean 100,000?

Yes its 1,00,000 records.

Re: Ajax Time Out in GL Inquiry

null@example.com (boxygen) — Sat, 04 Aug 2018 18:02:01 +0000

@poncho1234 yes lac is 100,000 in our local language

Re: Ajax Time Out in GL Inquiry

null@example.com (boxygen) — Sat, 04 Aug 2018 18:00:50 +0000

@kvvaradha, you are right. Thanks alot

I got the problem. One of my customization was basically causing the issue. I must have checked that without customized code.

Regards.

Re: Ajax Time Out in GL Inquiry

null@example.com (poncho1234) — Sat, 04 Aug 2018 17:59:30 +0000

@kvvaradha whats a lac? Do you mean 100,000?

Re: Ajax Time Out in GL Inquiry

null@example.com (kvvaradha) — Sat, 04 Aug 2018 17:53:47 +0000

@boxygen, This is not optimal solution. The actual problem is different. 300 records is not big thing. more than 1 lac records queried and display the results even in shared hosting without changing FA timeout. There is some other issue causing this issue. May be inefficient query is there to consume more RAM to get it expire the time limit.

Re: Ajax Time Out in GL Inquiry

null@example.com (poncho1234) — Sat, 04 Aug 2018 14:38:54 +0000

How long is it now?

I've seen 600 secs recomended as max, (setting to 0 is unlimited, but maybe other timeouts in http so beware) From my understanding its a security issue.

Does your host allow changes?

~~This SE post is interesting, can you add a variable based on number of records?~~

Google is your friend

Re: Ajax Time Out in GL Inquiry

null@example.com (boxygen) — Sat, 04 Aug 2018 13:58:48 +0000

I increased the max_execution_time so the problem mitigated but what if the records increases?

Re: Ajax Time Out in GL Inquiry

null@example.com (kvvaradha) — Fri, 03 Aug 2018 12:47:55 +0000

300 records does not a problem to query and get in FA time. it ends with bugs from the query results or the server may experience load problem. try take a backup of your database and check it on load free server like localhost or separate vps.

Try enable debuging mode to get errors on FA error.log

Re: Ajax Time Out in GL Inquiry

null@example.com (poncho1234) — Thu, 02 Aug 2018 13:48:35 +0000

Is it anything in php.ini or mysql.cnf settings???

Ajax Time Out in GL Inquiry

null@example.com (boxygen) — Thu, 02 Aug 2018 12:35:02 +0000

When querying one month transactions for a given gl account, the Ajax does not return any record because the number of records are around 300. What could be the solution for this? Can't we have multiple pages in the return of Query?