ASPX Page loads slowly

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi There,
I have a stored procedure which takes 7 sec to execute. I am using a
adapter and filling the dataset. Then I bind the datagrid with the
datatable from the dataset. When I test the page against the test
server DB, the page loads pretty fast. When I test the page against the
production server DB, it loads too slowly. The tables against which I
am testing are static tables both in the test DB and the production DB.
I am unable to figure out why it is behaving like this. Can anyone
please help me in this issue?

Thanks a lot.
Samy

.

Relevant Pages

  • Adding two a Datagrid
    ... Ok I have a sub that creates a Datatable ... loads some values then I bind it to a DataGrid to show ... I later need to add values to the third Column in that datagrid? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ViewState is HUGE
    ... just disable ViewState for the whole DataGrid and bind it every time the ... just disable the viewstate for the other fields, in order to do that you may ... > I'm showing 200 items in the grid, and when the page loads, the viewState ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ASPX Page loads slowly
    ... then I'd suggest caching it to avoid that 7 second wait. ... When I test the page against the test server DB, the page loads pretty fast. ... When I test the page against the production server DB, ...
    (microsoft.public.dotnet.framework.aspnet)
  • DataGrid Binding Problem
    ... I am trying to create an aspx page that displays a datagrid which contains ... the result of a query when the page loads. ... I am using WebMatrix. ... the data adapter and it returns the correcct data but when I load the page, ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • How to dynamically add a row to Datagrid?
    ... I have a datagrid that reads several rows of data from the database and loads ... I don't know what to put for the 2nd parameter since I am not reading the ...
    (microsoft.public.dotnet.framework.aspnet)