Re: Stored procedure timeout

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

I've eliminated parameter sniffing by declaring local variables in stored
procedure.
Asp page loaded in 2 seconds and after few hours it takes about 2 minutes
to load.
The problem is only with stored procedures called from asp page.
Any more suggestions?

Thanks in advance,
Grzesiek
.

Relevant Pages

  • changing txt to number
    ... but the field type is txt, in my asp ... do math with the data. ... Prev by Date: ...
    (microsoft.public.inetserver.asp.db)
  • Make rows invisible easier?
    ... Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Ming visits DaBear!
    ... but your actions have spoken volumes and I think can serve as a ... Jonathan Wolgamuth ... ASP since 2003 ... Prev by Date: ...
    (alt.smokers.pipes)
  • Base 64 Encode in C# / URL
    ... kann mir jemand auf die Sprünge helfen, wie ich folgenden vb-skript asp-code ... Danke Ralph ... Prev by Date: ...
    (microsoft.public.de.german.entwickler.dotnet.asp)
  • DataList in Table
    ... Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)