devxlogo

Improving performance

Improving performance

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

Answer:
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.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist