> Some calculations will need the full table to give accurate averages and the like?
> Create a RAM disk and just store a couple of single day files, one live and one
> processing the previous day. No need to 'delete' the content, just delete the
> file when finished?

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