I noticed that it is the server
that reaches 100%

I used ibexpert to execute the query. I have'nt tried
to execute it using isql yet but i'll try. I'm not
sure though if it would make a difference since its
the server that reaches 100%.

All the best,

rocky

--- Gabriel Reid <gabriel.reid@...> wrote:

> On Thu, May 05, 2005 at 10:26:52PM -0700, Rocky
> Castaneda wrote:
> > Whenever I would execute a stored procedure I
> notice
> > that the CPU Process reaches almost 100% though
> the
> > stored proc has already completed its process.
> >
> > Any comments, workaround on this issue?
>
> Can you see which process is hogging all the CPU
> (client or server)? Do
> you get the same behaviour if you execute the stored
> procedure in isql
> or something similar?
>
> Could you post a small working example?
>
> Gabriel
>

Discover Yahoo!
Get on-the-go sports scores, stock quotes, news and more. Check it out!
http://discover.yahoo.com/mobile.html