how can improve performance of page load in asp.net when we have large records?

Question

0.00/5 (No votes)

See more:

Hi all,

i have one page where i have created custom tables based on some different data from the database. query execution time is not issue, query returns more then 5000 records in 0 seconds, now based on different condition we are generating three tables using for loop to display these records on page. i am using devexpress xtrareport tool where i bind data by creating rows from for loop and this is taking forever time and at the end we got error request time out.

Posted 20-May-14 2:50am

ravikhoda

Add a Solution

Comments

Faisalabadians 20-May-14 8:52am

why you creating rows inside for loop? what are the requirements?

ravikhoda 20-May-14 8:55am

well on this page i can not use any controls like grid or repeater on the page. i need to use table object to manually show data on the page.

Faisalabadians 20-May-14 9:00am

why you don't ask from database for that data which you need to show? the amount you are telling is a high amount and if you are performing other activities along with separating rows inside for loop will definitely cause to request time out which is the feature of some time modern browsers and some time IIS configuration.

last thing I would suggest you to use LINQ to dataset to filter rows instead of applying for loop.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Stephen Hewison · Answer 1 · 2014-05-20T02:54:00

The web is not designed for displaying large datasets. You have to ask the question how useful is a list of 5000 records?

Personally I'd take another look at the problem and look for a more lateral solution such as adding search or pagination features.

But that said, if you're unsure where the delay is then you need to profile your code.

VS premium and ultimate both include profiling tools which will highlight the problem areas in your code.

If you don't have these editions try AntsProfiler from RedGate. There's a free trial. But please buy it if you like it.