Re: ASPX Page loads slowly

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

first of all, is there any chance to optimize the procedure? Do you have
indexes etc query structure correctly and done as much performance in mind
as possible?

When you say you test the Page for production DB, di you also have the page
on different server or on the same?

--
Teemu Keiski
ASP.NET MVP, AspInsider
Finland, EU



"Samy" <sampathkongala@xxxxxxxxx> wrote in message
news:1113320557.412125.296450@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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: test environment windows 2003
    ... an authorative restore after the demote and system state restore. ... This document was prepared for the building of a copy of the production ... Remove the physical cable for the new pc and build the member server ... Master Operation roles (FSMO and the File Replication service). ...
    (microsoft.public.windows.server.active_directory)
  • Re: Homegrown synchronization
    ... copying the zip file sitting there on the server to ... It is a filecopy of the zipped backend file from the server to the ... with the server whose SyncApp zips ups the production backend file ...
    (microsoft.public.access.replication)
  • RE: how analyze malfunctioning asp.net application?
    ... a product server, correct? ... unhealthy and teh worker process will be recycled. ... production debugging in your environment. ...
    (microsoft.public.dotnet.framework.performance)
  • Re: ISA/VPN difficulty
    ... W2K/ISA/VPN server and replacing it. ... The current one (production) works fine in terms of ISA and VPN ... The new machine does everything fine EXCEPT allow clients to do ...
    (microsoft.public.isa.vpn)
  • Re: WSS 3.0 beta 2 and Vista Server 2007 Beta 7
    ... r2) machine (not in production), and work with it from there. ... server that's in production? ... I'd suggest posting to the beta newsgroup but I don't know whether to ... System.Web.HttpApplication.InitInternal(HttpContext context, ...
    (microsoft.public.sharepoint.windowsservices)