As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.
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?
Posts: 81 | Location: Calgary, Alberta | Registered: August 07, 2003
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.
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?)
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003
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