Click here to Skip to main content
15,888,802 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
How to manage speed issues with respect to display of data in web pages when we are dealing with a large database

EDIT =============

Shortened the title, and DO NOT use abbreviations unless it's an industry-acccepted acronym.
Posted
Updated 16-Sep-10 9:44am
v5
Comments
R. Giskard Reventlov 16-Sep-10 2:35am    
pedal faster...
coderaug 16-Sep-10 2:38am    
Very Funny!!..

How about showing a 'Loading' or 'In Progress' message/icon?
Customizable 'Loading' Control for Web Applications with Designer Support[^]
 
Share this answer
 
Load less data, or reduce the number of controls on the screen that are being updated. You can do this by using a tab control, or a wizard form.
 
Share this answer
 
I believe the term large database means a database with large no of records....so in this situation you need to concentrate on two layers of the application..

1. The database layer.
2. The application layer.

1. Tune your database for faster access of data. Tune your queries by examining the execution plan. implement proper indexing of the tables.

2. In the application layer, use paging for data access (say 100 data per page). Use Repeater control for displaying the data (it requires a bit effort, as there is no default layout, but reduces the amount of viewstate than DataGrid or any other rich data bound control). If possible load the page using Ajax, so that the user experience doesn't becomes tiring.
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900