Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: SQL
Expertise: Beginner
Mar 24, 1997

Improving performance

The repeater in my application seems to be very slow in populating. Is there anything I can do to improve its performance?

Poor performance can be the result of a wide number of interacting factors, so to deliver a prescription with so little information would be inaccurate.

That said, I can offer a couple of places to look at for potential problems specifically related to repeaters.

Make sure your RowFetchMode is set to "Fetch As Needed" to avoid fetching all the rows that may eventually end up in the repeater at one time. Of course, if you need all the rows for some type of aggregate total, you will not have this option.

Second, if possible, reduce the number of derived fields that use the SqlLookup() method. Currently, OPO does an individual SQL statement for each lookup, so having three lookups could have some impact on the performance of the repeater.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date