--- In ib-support@yahoogroups.com, "Richard Pendered"
<rpendered@t...> wrote:

> I have had this before, and all i do is commit the transaction

every 10k

> records.

But you are using a third part tool, right? Because i can not commit
anything inside a trigger.

I am searching for the reason of this behavior to don´t have to use
these tricks, and be able to freely use direct updates from isql,
for example.

I'd like to know if it is normal and i have to use other tools to
make large updates, or there is something wrong with FB or with my
triggers.

PS: last test i did i had to restart the server, because i run out
of swap space, lost system login ability, etc...

Thanks for the answer

>
> -----Original Message-----
> From: fabiano_bonin [mailto:fabiano@l...]
> Sent: 09 May 2003 14:30
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Exponential loss of performance
>
>
> FB 1.5 RC1 REDHAT 8.0
>
>
> hi, i need some help. i have a table (table1) that have an update
> trigger that can insert or update another table (table2).
>
> this trigger execute 3 queries on table1 itself and 1 query on
> table2. all queries inside the trigger are based on indexed fields.
>
> table1 have aprox. 70.000 records.
>
> if i update 10.000 records of table1, it takes aprox. 10 sec.
> if i update 20.000 records of table1, it takes aprox. 30 sec.
> if i update 30.000 records of table1, it takes aprox. 60 sec.
>
> now i am trying to update all 70.000 records of table1 for 10
> minutes and it doesn´t reach the end yet.
>
> i´d like to know if it is normal and why it happens, or, if it´s

not

> normal, i can try to make a reproducible test based on my db.
>
> thanks.
>
>
>
> 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/