In my app I have many tables which work ok (mysql+IIS)
One table has 208 fields, most of them are listbox or radio with lookup tables.
When I add a new record, it tooks a lot of time to complete the ajax loading, and sometimes some selects are not filled, without any console error.
Any experience or best practice on managing this kind of scenario?
It seems to me that the mysql performance and server performance are ok, maybe I have to manage some IIS or ASP.NET parameters?
lookup fields performance
-
- User
- Posts: 111
lookup fields performance
-
- User
- Posts: 150
Question, each listbox/radio field has it's own view for the list of values?
-
- User
- Posts: 111
I investigated further.
The problem is in /api/lookup
Many lookups work well, until one (and the following ones) fails with 500 error code "Unable to connect to any of the specified MySQL hosts"
It seems that MySQL is receiving a lot of calls thru api/lookup and at a certain point it closes the connection.
Checking the browser "network" data, there are 155 requests when I click on the plus icon to add a new record. Most of these are api/lookup and some of them abort.
Any idea to solve this?
-
- User
- Posts: 1112
Andros wrote:
... when I click on the plus icon to add a new record. Most of these are api/lookup...
Try enable Lookup cache enabled pages for the Add and Edit pages.