Which database do you use ?
I donĀ“t know mySql ... but I know Sybase very well and there you have
something called Triggers ...
[Cite SybaseDoc]
A trigger is a stored procedure that goes into effect when you insert,
delete, or update data in a table
[/CITE]
You could say for example
Create trig
I'd suggest only inserting data into the "working" table throughout the
day, then on a nightly basis drop the index on the archived table, import
the data from the working table into the archived one, re-create the
index and clear out your working table.
As time goes on that archived table is goi