• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

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

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
rss2
Asked:
rss2
1 Solution
 
elimesikaCommented:

HII

How many seconds the SP is running when you are executing it directly against the sql server ?
0
 
rss2Author Commented:
That was the problem. But at least those sps aren't mine. :) Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now