Subject RE: [firebird-support] Delete advice
Author Alan McDonald
> 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.
>

and why don't you use a calculated column
or
just update rows with a calculated value?
Alan