Subject Delete advice
Author Mr. John
Hi !
I have an old application that works with .mdb file and I have to rewrite it and this time I'll use Firebird for data storing.Application does some calculations in one table,method used : delete every row and add new calculated rows,calculation is done several times on a day.I think this will grow my database and I don't like this way and I plan to use one field active_,to set 0 before calculation,then I'll use Update or Insert with active_=1 and finally I'll delete only rows with active_=0.
Am I doing right this way?

Thanks for any advice.




[Non-text portions of this message have been removed]