The slow down occurs almost as soon as the procedure begins.

The server starts grinding and all other operations virtually stop.

Todd



Luciano A. Sparacino wrote:

> Do you experience a slow down of the performance after a couple of hours
> that your application is running? Because if so, you should take a look at
> the OAT/OIT discussions in this list (i mean you could have a transaction
> control problem).
>
> Ing. Sparacino Luciano
>
> New Business S.A.
> Tel (+54) (11) 4666-9898 ext 224
> Fax (+54) (11) 4666-7500
> e-mail lsparacino@...
>
> ----- Original Message -----
> From: "Todd Brasseur" <todd@...>
> To: <ib-support@yahoogroups.com>
> Sent: Thursday, December 05, 2002 7:40 PM
> Subject: [ib-support] Performance
>
>
> > Our application has some processes that run for an extended period of
> > time(up to 4 or 5 hours) as there is alot of complicated calculations.
> > These processes are written with Stored Procedures (One main
> > procedure that may call many other procedures.)
> >
> > We are experiencing problems where when these procedures are running,
> > they take over the server. IBServer shows it is taking 99% of the CPU
> > causing all other users to virtually stop when trying to access the
> > server.
> >
> > We experience a similiar problem when users run complicated queries.
> >
> > 1) Is it adviseable to process these types of calculations in Stored
> > Procedures or should they be written in C++?
> >
> > 2) Is there something we can do to ensure the server isn't taken over
> > by Firebird?
> >
> > Any help would be appreciated.
> >
> > Todd Brasseur
> > COMPASS Municipal Services Inc.
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
> <http://rd.yahoo.com/M=240188.2647639.4038785.2225243/D=egroupweb/S=1705115386:HM/A=1321406/R=0/*http://www.e-dealsdaily.com/soundbug/>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .

--
Todd Brasseur, A.M.A.A.
COMPASS Municipal Services Inc.




[Non-text portions of this message have been removed]