I have created database on sqlserver and connected it to website. the database table holds > 10,000 records. When I up my site live. All my application connected to that server causes slow. Why this is happening.
-
-
probably because you are displaing too many records at once.
From my experience trying to display more that a few hundred records on a web page can take a long long time to render.
It is not that the database is slow, the records are returned to the client quite quickly, but then the web browser has to draw the data onto the web page and that can take a long time. That has been my observation anyhow.
Design your pages so that it shows you a summary that you can drill down
from for more detail about a particular summary record.
Or displays data 1 month or 1 week at a time with selectors to choose which month or week you want to look at.
The less data you page has to display the quicker it will be.
Incidentally
I use both asp (not DotNet) as well as client side java/vb script along with regular html to display my data in a business reporting/application environment
Comment