Page 1 of 1

select field with Multiple checkbox selected

Posted: Tue Apr 16, 2024 8:32 pm
by darkdragon

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


Re: select field with Multiple checkbox selected

Posted: Wed Apr 17, 2024 7:23 am
by MichaelG

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


Re: select field with Multiple checkbox selected

Posted: Wed Apr 17, 2024 4:21 pm
by darkdragon

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

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


Re: select field with Multiple checkbox selected

Posted: Wed Apr 17, 2024 10:22 pm
by MichaelG

MichaelG wrote:

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

  1. Find out from above which script exactly caused the delay.
  2. 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.
  3. If you have server events, remove them to test. Or create a clean project from your database to test.