how to make data load fast in asp.net

Question

2.00/5 (2 votes)

See more:

HI all,

i am generating a table from a database where my select query get around 10k of records. now on C# side i am using table object and generate each rows based on some condition from the data. everything works fine but the speed of rendering the data is very slow on the browser and everytime i got request time out error. i can't use grid , repeater or any kind of jQuery grid due to some obvious reasons. can someone please tell me how can i improve the speed or how can i break the data so it loads faster.

my table is a single page kind of thing there is no paging , sorting or searching. so can not apply the rownumber logic to load only data equal to pagesize or something.

Posted 21-May-14 19:26pm

ravikhoda

Add a Solution

Comments

Nayan Ambaliya 22-May-14 1:43am

You could use a combination of update panel and user control to have the page loaded and let the data load later and take its time.

However, this might not be your answer.
You need to describe your conditions on why you need to loop through rows and use a table object and not the grid view. Mind well that the more you display on the page, more time is taken to draw it on the page and hence the rendering of the page will be slow depending on your data and logic to show/hide rows.

Please state what technique you use to filter the rows and then to display them.

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)

Sunasara Imdadhusen · Answer 1 · 2014-05-21T19:39:00

Solution 1

Hi Ravi,

There is several way to increase speed and performance of your application. Changing on Database side or Server side code.

for example at Database level.
You can create view and indexing

for server side
You can use AJAX, Repeater to show limited records at first time when user make request for next records then do ajax call to get only those records from the server side.

Posted 21-May-14 19:39pm

Sunasara Imdadhusen

Comments

ravikhoda 22-May-14 2:51am

well database side things work fine. my query execution time is less than 1 sec. and on code side i can not use grid, repeater or any ajax thing as i am integrating this to some third party tools which do not supports any asp controls.