[...] > 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
