select field with Multiple checkbox selected

darkdragon · Post by **darkdragon** » Tue Apr 16, 2024 8:32 pm

Hi all,

We have some performance issues with a form (no matter if it is opened on a separate page or in modal), where we have 3 fields with multiple options.
The "edit" page loads in around 20-30 seconds. If we uncheck Multiple option from all these fields, the form loads instantly.

There is no bottleneck on SQL, we checked with SQL Server Profiler, all queries are instant.

Regards

MichaelG · Post by **MichaelG** » Wed Apr 17, 2024 7:23 am

Enable debug (Tools -> Advanced Settings -> Debug), press F12 -> Network to check the network response.

darkdragon · Post by **darkdragon** » Wed Apr 17, 2024 4:21 pm

"Waiting for response from server" ... 40 seconds.

The project was merely converted from ANM2023 where it worked perfectly.

MichaelG · Post by **MichaelG** » Wed Apr 17, 2024 10:22 pm

MichaelG wrote:

press F12 (in your browser) -> Network to check the network response.

Find out from above which script exactly caused the delay.
If it is the page itself, go to the log file check the execution time of the SQL. (Make sure you have enabled Debug, Log to file and Log SQL so you can check the log file for more useful info.
If you have server events, remove them to test. Or create a clean project from your database to test.