Solved

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

Posted on 2008-06-12
2
200 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
Comment Utility

HII

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

Author Closing Comment

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

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

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…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now