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.
DropDown List -very slow on reference
DropDown List -very slow on reference
Last edited by weblike on Wed Jun 19, 2019 8:17 pm, edited 1 time in total.
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
Re: DropDown List -very slow on refernce
Yes the fields are indexed.
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
Re: DropDown List -very slow on refernce
1. Tested the MySql health with webyog.com. All good.
2. Linked that table to a PHP mini app and created a form for testing. It's opening almost instantly.
3. In Aware changed the combobox with a PICK FROM query, it's working instantly.
Defently comboboxes has problems and are not optimized.
2. Linked that table to a PHP mini app and created a form for testing. It's opening almost instantly.
3. In Aware changed the combobox with a PICK FROM query, it's working instantly.
Defently comboboxes has problems and are not optimized.
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
-
- Posts: 7527
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: DropDown List -very slow on reference
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
Aware IM Support Team