> 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