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