We have several customers who have hundreds of invoice daily i.e 200 invoices…so in just 3 days they will have around 600 outstanding invoices…when we’d like to make payment via payment entry…I’m facing strange behavior…
If the customer only has around < 100 outstanding invoices , then everything goes normally. when we select party the the screen only freeze 2-4 seconds to load the data…
If the data is over 200 invoices then we select party, nothing’s happened at the beginning but after around 30sec the screen is freeze for quite long time…sometimes getting timeout
Okay, via override_whitelisted_methods hook, I limit sql query to e.g. 50 records…but the behavior is still same…but references table shows only 50 records…I increased http_timeout to 600 too
Can anybody give some pointers how to solve such case? Since I have limited the query to only max 50 records…why there’s still delay around 15-30 sec before the screen freeze to populate reference table…Is it javascript issue? async issue? or?? this only happens with customers who has hundreds of outstanding invoices…seems the query is not executed right after we select party…if the customer only has few invoices then the query is run right after we select party…
PS. I changed file under erpnext.accounts.utils.get_outstanding_invoices for this test to limit the query. I’m using latest v10
I have limited the query to retrieve only 15 outstanding invoices…but after selecting party, it delayed +/- 20sec before populating reference table…What might the issue here?
Can anybody give some pointers what’s going on here? there’s delay before it loaded reference table even the query already limited to 5 records…it seems somewhere the full-records query were still running in background… To test it I changed the core query directly under accounts > utils > get_outstanding_documents…still no luck… have no ideas now,…it’s just annoying for end users…
The problem still existed then I changed core file directly under erpnext.accounts.utils.get_outstanding_invoices to limit sql query to only 5 records…but still no luck…the delay still exists for around +/- 20-30 sec
The delay is gone if the party only has few records (under 100)…it seems javascript issue…I’m on latest v10
Not sure if this will help or is relevant, but you might want to check your server’s ping time.
I am encountering the same issue with timeout from one of our remote sites accessing ERPNext and it turns out that the ISPs server was timing out which in turn caused ERPNext to timeout.
Basically, ERPNext is installed in one country, I am in another and the remote site is in another. I am not experiencing any timeouts. But the remote site is.
I really don;t know what’ss actually happening here…one customer only has 5 outstanding invoices…But the waiting time aka TTFB reached 3,8 minutes which is very long and slow …this is big problem…anybody can give some ideas ?
