Re: ASPX Page loads slowly

If this data is static, then I'd suggest caching it to avoid that 7 second wait. If this data must be dynamic and reloaded each time then I'd suggest looking at and profiling the SQL to figure out what's taking so long.

-Brock
DevelopMentor
http://staff.develop.com/ballen



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

  • Re: Odd message from cron daemon
    ... > Roland Smith writes: ... >> command and fails. ... > files are identical on my production server and on my test server: ...
    (freebsd-questions)
  • Re: fastest way to duplicate production server?
    ... install the new versions of Apache/MySQL/PHP in the test server ... production server. ... Just install mysql, no ... as you gonna copy over the configuration and grant ...
    (freebsd-isp)
  • ASPX Page loads slowly
    ... Then I bind the datagrid with the ... production server DB, it loads too slowly. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Odd message from cron daemon
    ... > command and fails. ... files are identical on my production server and on my test server: ... mysterious message is being mailed to me only on the test system. ...
    (freebsd-questions)
  • Strange Occurance on Live but not on Test Server
    ... I have a fairly simple ASP.Net app that is a Business Card order form. ... This works perfectly on my test server. ... However, on my production server, ... the first time I, or anyone, clicks on that Show Me button, it refreshes the ...
    (microsoft.public.dotnet.framework.aspnet)