Subject Exponential loss of performance
Author fabiano_bonin
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.