Click here to Skip to main content
15,887,214 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi,
i am building a web app but it takes too time in load and fetching database , how to solve this problem
Posted
Updated 26-Jul-13 6:18am
v2
Comments
Nelek 26-Jul-13 8:37am    
[no name] 26-Jul-13 8:41am    
Well based on the enormous amount of information that you have given us about your problem, stop loading so much and stop "fetching database" and that should speed you right up.
Jean A Brandelero 26-Jul-13 9:01am    
Stupid answers don't help in any way.
This can be a problem with your hosting, network latency.
The size of images can be a problem too, try saving your images in PNG.
For the database, the problem can be on your querys, joins and indexes.

There are many places that can cause slow down. You'll need to look at how you are fetching data, how much of it, if you can improve that speed. Etc, etc.
 
Share this answer
 
You can do following things. I even don't know much techniques

1.) Use stored procedures.
2.) For heavy images use generic image handler.
3.) Use HTML controls as much as you can ,as they are light weight.
4.) Caching is one of the most important thing you can do.
5.) Proper 3 tier architecture is quite important.
6.) Use Update panel ,avoid full post backs.
7.) If not necessary check that you controls AutoPostBacks are off.
8.) If you are capable use ajax calls for non secure data.
9.) Most important you should have good hosting environment.
10.) Use Classes and ArrayLists as opposed to returning an SqlDataReader.
11.) Use SqlDataReader most of the times ,as if brings data in a single chunk.

etc....
 
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