I have a repeat control designed to display summary data for some users (in this case, 5 different users) The summary data itself is retrieved by a dblookup from a view of active documents. So, my repeat formula uses a dblookup to get the user names for my collection, then I have a one row table inside the repeat that uses each username to get the summary data with another dblookup (one per row).
To my shock and surprise, this page takes SIX MINUTES to load. To find the problem, I added some print statements in my hidden field that gets the data for each user. I suspected this was taking too long. What I found was that even though I have just one row per user, the formula was performing a dblookup 6 times for each user!
10/11/2010 03:31:53 PM HTTP JVM: getting data for 051A~Julie Walters…
10/11/2010 03:32:03 PM HTTP JVM: data retrieval complete for 051A~Julie Walters
10/11/2010 03:32:12 PM HTTP JVM: getting data for 051A~Julie Walters…
10/11/2010 03:32:21 PM HTTP JVM: data retrieval complete for 051A~Julie Walters
10/11/2010 03:32:21 PM HTTP JVM: getting data for 051A~Julie Walters…
10/11/2010 03:32:30 PM HTTP JVM: data retrieval complete for 051A~Julie Walters
10/11/2010 03:32:30 PM HTTP JVM: getting data for 051A~Julie Walters…
10/11/2010 03:32:39 PM HTTP JVM: data retrieval complete for 051A~Julie Walters
10/11/2010 03:32:39 PM HTTP JVM: getting data for 051A~Julie Walters…
10/11/2010 03:32:48 PM HTTP JVM: data retrieval complete for 051A~Julie Walters
10/11/2010 03:32:48 PM HTTP JVM: getting data for 051A~Julie Walters…
10/11/2010 03:32:57 PM HTTP JVM: data retrieval complete for 051A~Julie Walters
Can anyone tell me why this is happening?
These print statements are directly before and after the dblookup command in my hidden input control, default value. It should only perform the dblookup once per user.
Consider, however, that even with the lookups being performed 6 times, it still only takes about one second to do all these, so 5 users would still only consume 5 or 6 seconds. Why would this page be taking SIX minutes to load??? (yes, MINUTES)
What am I missing?
(no page load events for this page)
(oh, and the dblookup for the repeat results takes 0.01 seconds)