On Sat, May 07, 2005 at 06:01:48AM -0700, Rocky Castaneda wrote:

> 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%.

If it's the server that is going to 100% CPU and you're running the
query in ibexpert (and *not* a java-based client), then I would suggest you
direct this problem at the firebird-support mailing list (this list is
specifically related to the JDBC driver that interfaces with Firebird).

If you try the stored procedure in ISQL, you may want to try showing
statistics and the query plan for a clue on the CPU usage (this is
probably also an option in ibexpert).

Gabriel

>
> --- 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
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>