DropDown List -very slow on reference

If you think that something doesn't work in Aware IM post your message here
Post Reply
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

DropDown List -very slow on reference

Post by 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.
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
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: DropDown List -very slow on refernce

Post by tford »

Is it indexed?
Tom - V8.8 build 3137 - MySql / PostGres
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

Re: DropDown List -very slow on refernce

Post by weblike »

Yes the fields are indexed.
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

Re: DropDown List -very slow on refernce

Post by weblike »

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.
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: DropDown List -very slow on reference

Post by 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
Aware IM Support Team
Post Reply