<![CDATA[FrontAccounting forum — New sales_order_entry.php very slow]]>2024-05-16T11:56:49ZPunBBhttps://frontaccounting.com/punbb/viewtopic.php?id=10517<![CDATA[Re: New sales_order_entry.php very slow]]>No - there is only one currency in use, so that cannot be the reason.
But both customers who experience this problem - they also have over 15000 transactions.
]]>https://frontaccounting.com/punbb/profile.php?id=3832024-05-16T11:56:49Zhttps://frontaccounting.com/punbb/viewtopic.php?pid=43109#p43109<![CDATA[Re: New sales_order_entry.php very slow]]>Are those customers have home currency or different currency..
If different. May be the exchange rate issue.
]]>https://frontaccounting.com/punbb/profile.php?id=193482024-05-15T17:18:17Zhttps://frontaccounting.com/punbb/viewtopic.php?pid=43105#p43105<![CDATA[Re: New sales_order_entry.php very slow]]>Hello Changing the PHP version doesn't make a difference. There are quite a few products. There aren't as many customers. What I discovered is that the query is slow when the customer is already selected. For example, creating the following invoice or when I have looked at transactions for the respective customer before (then the customer is already selected by default when creating a new invoice). And here is the difference - I have two customers who have a considerable number of invoices every day. These customers are extremely slow. If the preselected customer has had few transactions - there are no problems. But these two customers have had thousands of orders, and this problem occurs specifically with them. Can I put some additional code somewhere to see the time of SQL queries, so I can figure out why it is slow for these customers - what query takes so long?]]>https://frontaccounting.com/punbb/profile.php?id=3832024-05-15T09:57:27Zhttps://frontaccounting.com/punbb/viewtopic.php?pid=43102#p43102<![CDATA[Re: New sales_order_entry.php very slow]]>1. Do you have more than 5000 entries in items or customers ?
2. Did you check php version like 8.2 or 8.1
]]>https://frontaccounting.com/punbb/profile.php?id=193482024-05-15T08:24:00Zhttps://frontaccounting.com/punbb/viewtopic.php?pid=43097#p43097<![CDATA[New sales_order_entry.php very slow]]>Hello Since the weekend, entering sales invoices has suddenly become extremely slow. The Inspection tool shows that opening the sales_order_entry.php file takes 2.2 minutes! However, all other FrontAccounting functions are working at normal speed. Where or how should I start investigating what the problem is? The trouble started over the weekend when the hosting company had an issue with the MySQL server. FrontAccounting 2.4.18 PHP - 8.3 MySQL - 10.6.17-MariaDB-cll-lve MySQL table optimization done]]>https://frontaccounting.com/punbb/profile.php?id=3832024-05-15T03:19:16Zhttps://frontaccounting.com/punbb/viewtopic.php?pid=43095#p43095