Ok thanks

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

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

Discover Yahoo!
Stay in touch with email, IM, photo sharing and more. Check it out!
http://discover.yahoo.com/stayintouch.html