inconsistancy in execution time of SP. Need help.

Hi,
I have a stored procedure which creates a temporary table and insert into it
selected entries.
When executing the procedure, selecting few thousands entries, it takes few
MINUTES for it to finish.
When executing the same code in the query analyzer it takes a second to
finish.
I can't work as the accessing web page fails to get the data because of the
long time it takes.
Does anyone have an idea what's wrong with my procedure?
Thanks,
I.P.You're seeing sp recompiled. I suggest you take a look at this kb.
http://support.microsoft.com/kb/243586
-oj
"I.P." <lafafa@.yahoo.com> wrote in message
news:d7hce4$b86$1@.news.iucc.ac.il...
> Hi,
> I have a stored procedure which creates a temporary table and insert into
> it selected entries.
> When executing the procedure, selecting few thousands entries, it takes
> few MINUTES for it to finish.
> When executing the same code in the query analyzer it takes a second to
> finish.
> I can't work as the accessing web page fails to get the data because of
> the long time it takes.
> Does anyone have an idea what's wrong with my procedure?
> Thanks,
> I.P.
>|||Thanks.
"oj" <nospam_ojngo@.home.com> wrote in message
news:O7xa0gcZFHA.3780@.tk2msftngp13.phx.gbl...
> You're seeing sp recompiled. I suggest you take a look at this kb.
> http://support.microsoft.com/kb/243586
>
> --
> -oj
>
> "I.P." <lafafa@.yahoo.com> wrote in message
> news:d7hce4$b86$1@.news.iucc.ac.il...
>