Solved

Web Application takes 60 seconds to load up, and need to display 1000s of records

Posted on 2008-06-12
2
206 Views
Last Modified: 2013-11-26
Hi Experts,

I have an aspx page with two html tables on it and various other asp.net and ajax toolkit controls.

My first problem with this page is the load up, as it takes 60 seconds of staring into white space before it loads. I can fine tune my stored proc queries (add indexes, whatever) and I can remove some controls I could do without, but it's not making it much quicker. I've looked at recommendations to load the controls AFTER loading the html, but that seems dicey and I'm no pro-coder.

It seems to me there is so much over-head with ASP.NET that outweighs the benefit of using asp.net..

I used to use gridviews, not I'm looping through the dataset and building dynamic html table, just so I can have quick, javascript sorting, filtering, and paging on the client..but this only works well with <100 rows. Anything more, and my memory gets eaten up.

The second problem is that one of the tables needs to display 3000 records. And I need to be able to filter, sort, and page quickly.

It seems to me that if I can remove the loading up of these asp.net controls, then I could just go back to using a streamlined html page with javascript. But then the table with the large dataset is still a problem.

So could you guys give me some advice on the way forward here? I'm totally stuck. :(

Thanks,
rss2
0
Comment
Question by:rss2
2 Comments
 
LVL 19

Accepted Solution

by:
elimesika earned 500 total points
ID: 21772773

HII

How many seconds the SP is running when you are executing it directly against the sql server ?
0
 

Author Closing Comment

by:rss2
ID: 31469105
That was the problem. But at least those sps aren't mine. :) Thank you!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question