DropDown List -very slow on reference

weblike

Hello,

In a form when a user is trying to expand a dropdown list of references -> 20-30 seconds the spinning sign is appearing and only after that the dropdown is showing. Very annoying.
Does anyone found a solution inside forms to have instant dropdowns of references?
I have serched the forum and found only 2 posts about this problem but no solution (only workarounds).

Thank you.

tford

Is it indexed?

weblike

Yes the fields are indexed.

weblike

Tested the MySql health with webyog.com. All good.
Linked that table to a PHP mini app and created a form for testing. It's opening almost instantly.
In Aware changed the combobox with a PICK FROM query, it's working instantly.

Defently comboboxes has problems and are not optimized.

aware_support

In one of the latest builds if you specify the page size of the drop down only the "pageSize" number of records will be returned. In older builds page size property was ignored. This should fix the problem