[...]

> ufortunatly the stat i need are created mostly from trigger :(

> For exemple imagine a table with a field 'NB_total_update_in_the_database' and every
> time a row is updated in any table i need to increase this value by +1. problem i can
> not do directly or i will go in deadlock (multi users database) so i need to create a
> temp table where i simply add a row with +1 and at the end of the day calculate the
> aggregate of such data to update the value of NB_total_update_in_the_database

You could use a sequence/generator for that without multi user problems and very fast.


--
Björn Reimer - RRZE