Subject | Exponential loss of performance |
---|---|
Author | fabiano_bonin |
Post date | 2003-05-09T13:29:43Z |
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.
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.