Re: stored procedures are slow!!!
From: Josyula Sivaram <josyula0071_at_home.com>
Date: Thu, 26 Apr 2001 01:21:00 GMT
Message-ID: <0KKF6.44850$JI6.237057_at_news1.rdc1.tx.home.com>
Date: Thu, 26 Apr 2001 01:21:00 GMT
Message-ID: <0KKF6.44850$JI6.237057_at_news1.rdc1.tx.home.com>
why dont you try pinning the procedures, if they are frequently called. that
should help at least.
"Arni" <arnidesire_at_optushome.com.au> wrote in message
news:6RgF6.3631$p5.11361_at_news1.rivrw1.nsw.optushome.com.au...
> just a question.....
> aren't stored procedures supposed to be faster than sql statements in asp
> code since they are executed and not interpreted????
>
> it is taking much longer to call a stored procedure using jscript in asp
> (server side) than sql statements passed through asp code.. is this
unusual
> or normal???
>
> then why use stored procedures at all..???
>
> Arni...
>
>
Received on Thu Apr 26 2001 - 03:21:00 CEST