Topic: Ajax Time Out in GL Inquiry

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?

www.boxygen.pk

Re: Ajax Time Out in GL Inquiry

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

Re: Ajax Time Out in GL Inquiry

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

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

www.boxygen.pk

5 (edited by poncho1234 08/04/2018 06:00:09 pm)

Re: Ajax Time Out in GL Inquiry

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

@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

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

Re: Ajax Time Out in GL Inquiry

@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.

www.boxygen.pk

Re: Ajax Time Out in GL Inquiry

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

www.boxygen.pk

Re: Ajax Time Out in GL Inquiry

poncho1234 wrote:

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

Yes its 1,00,000 records.

Re: Ajax Time Out in GL Inquiry

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

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.

www.boxygen.pk