Subject | Delete advice |
---|---|
Author | Mr. John |
Post date | 2008-08-30T06:55:32Z |
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]
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]