I have had this before, and all i do is commit the transaction every 10k
records.

-----Original Message-----
From: fabiano_bonin [mailto:fabiano@...]
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/