Focal Point
Slow loading listboxes

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5321077331

February 18, 2004, 03:31 PM
Nightowl
Slow loading listboxes
We have an html launch page setup with a half dozen listboxes. It seems to take a while to load these list boxes from the database. We are using the dynamic control values method from the Resource Layout tool. Is there a way to find out what Webfocus is doing in the background to load the listboxes? I suspect it is going against the whole table to find all the distinct values. Should we write a stored proc to do this?
February 21, 2004, 12:19 AM
Vivian
What we did was to have a nightly scheduled run of all the lists that would be used in the form. Then just include those lists (found thru a filedef) in your html.

Since the lists were pre-generated the forms would load nearly instantly.

Hope that gives you some ideas.

Vivian Perlmutter
www.aviter.com
vivian@aviter.com
February 23, 2004, 11:25 AM
susannah
i totally agree with Vivian. i,too, generate all my lists as part of my etl procedures (hourly refreshed) and place them so that they can be filedeffed in my MRE as well as read by my self-serv .asp launch pages as serverside includes.
Creating them, i define a variable that is the complete option tag.
OUTPUT/A100='[OPTION NAME=MYITEM VALUE="' | MYVAR | '">choose this region[/OPTION>';
and then print one OUTPUT value for each value of MYVAR as a format alpha file which gives it a .txt extension. Just change your mre launch pages from html pages to fexes (copy and paste)
and then start your mre launch page/fexes with FILEDEFS to your text files, followed by the html tag and the rest of your launch page .
Does this help?(you know those brackets are left carets, right?)
February 23, 2004, 02:03 PM
Nightowl
Thanks ladies, I'll try your suggestions. This technique should probably do the trick.
February 24, 2004, 07:47 PM
<mhuber>
Our DBA's were kind enough to have created lookup tables containing all the possible values. We leverage these tables, and our drop-downs only take a few seconds to load.

You can check out the actual queries by looking in your Temporary Internet Files folder (same place where cookies are stored). You'll see some XML docs with the adhoc fex embedded in the name. Basically, it does:
TABLE FILE SOMEFILE
SUM
FST.VALUE_FIELD
FST.DISPLAY_FIELD
BY
VALUE_FIELD
ON TABLE PCHOLD FORMAT XML
END

So yes, it does a full-table-scan.
-Michael