Controls extremely slow to load on first click

[becks774]

Hello,

My app is a list at the top (master), a list on the left (children) and detail controls on the right (detail of child). The user is to pick something from the list at the top (parent) and the children are displayed in the list at the left. When you select a child in the list on the left, it's details are displayed in the controls on the right. Two of the controls on the right are drop down lists that are databound.

The issue is, the first time you click on a child, the page freezes for about 2 minutes and it takes that long to populate the detail controls and for the page to be responsive. After the first child click, clicking on other children reloads the detail controls very quickly. Even if you change parents, switching between the children in very quick as well. It is just getting past the initial 2 minutes that is unacceptable. If I remove the data binding from the 2 drop down controls, the response is always good (but I need them to be lists so I can't just forgo the data binding).

Other info:
I store the data for the 2 bound controls in the cache. I check the cache and if it is null, I fetch from the database.
The list on the left is in 1 update panel triggered by the index change of the parent list.
The detail controls on the right are in an update panel triggered by the index change of the list on the left.

Any help would be greately appreciated. I have searched and searched and cannot locate a post that has helped.

Thank you in advanced.
Becca

 

[jmeckley]

how much data and what's the query plan? chances are either too much data is returned, making a DDL impractical) or the query to fetch the data is not optimized. caching the data, treats the symptoms, not the root problem.

there are also a few other things you mention which could be potential pain points, but most of that is related to webforms in general.

Jason Meckley
Programmer

faq855-7190
faq732-7259

 

[becks774]

Hi jmeckly,

Thanks for responding.

It is not much data at all. About 20 records at 10 columns wide, largest being a varchar(50) all from the same table (no joins, etc).

In testing, I found that if I turn the ScriptManager enable partial rendering to false, everything works super fast. Defeats the purpose of using the update panels but the flickering is better than 2 minutes of non-responsive load time!

Becca

 

[jmeckley]

I would recommend replacing the update panels with true ajax/json requests. an update panel is just a full postback wrapped in a ajax request. there is no preformance gain. the only benefit is the browser is not refreshed.

Jason Meckley
Programmer

faq855-7190
faq732-7259

 

[becks774]

Thanks Jason! I will look into that.