Request Timeout error

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

i have created a web application where on button click details of all the students present in particular time duration is displayed in a gridview. Here if the duration is less i.e a day or a week the gridview is displayed but if i take the duration of a month or more than that the application in the browser keeps on running and after some time browser not responding msg is shown. Do i need to make some changes in configuration to display a large bulk of data?

Posted 8-Jan-15 1:18am

Member 11316644

Add a Solution

Comments

Arjsrya 8-Jan-15 7:38am

What is the purpose of showing large amount of data to the user.Would you show one million records to the users?Navigating from one page to another is goona be pain to the user.

2 solutions

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)

Praveen Kumar Upadhyay · Answer 1 · 2015-01-08T01:25:00

Solution 1

That is because it is taking too much time to load the data in the browser. The browser is not meant to display to such large amount of data. What you can do instead, load first 100 records display in the Grid and on next Page click load another data.

Try to find a solution which will load the data on demand, means when you click on next/previous then it should load the data. But this is suggested only in case you want to display such large data.

Posted 8-Jan-15 1:25am

Praveen Kumar Upadhyay

Comments

Member 11316644 8-Jan-15 22:09pm

I have another application in which i have to export large amount of data to an excel file. In that application also i am facing the same error . Before retrieval of data it is not able to load the data in to excel sheet and the browser ultimately shows not responding message . the same thing works if data retrieved is less. Is there any problem with configuration that it works for small data and not for large.

Praveen Kumar Upadhyay 8-Jan-15 23:17pm

You can do the same in case of writing to excel. Load some 5-5 thousand of record and write to excel.
Let the connection open and loop with 5-5 thousand record and write to excel.
Also note for downloading always zip the file.

Arjsrya · Answer 2 · 2015-01-08T01:36:00

Load data whatever required for the user.As per praveen suggestion,just load only few amount of data at the initial time.

You can use Pagination & Multi threading.

No one is going to look huge amount of data in a gridview.Just load whatever required for the user or give a search functionality.

If you load millions of records in a gridview,It will even decrese the performance of your application.