Subject Re: [ib-support] large deletions
Author Jason Chapman (JAC2)
That's a pretty scary number of "fluff" records 36 - 72 million a year. We
have a DB with 100 million + records and it gets a little flustered if you
ask it the wrong question (that requires multiple index merges).


""Raul Chirea"" <raul_chirea@...> wrote in message
> Hi Bob,
> From: "Bob Lazarchik" <bob5407@...>
> > I have a log database used in manufacturing tools that creates up to
> 100,000 - 200,000 entries
> > daily. I need to clean out records that are more than 8 days old on a
> daily basis and I am looking
> > for some ideas on how to do this. The constraints are that this tool
> continue to run during
> > the clean up process. The options I've tried suck up alot of CPU time
> interfere in the
> > operation of the tool (timing is a very big issue in the type of testing
> this tool does) . I thought
> > about spawing a thread with its own connection once a day to do this
> cleanup but am unsure of
> > how safe this is. I have SP's in the database for doing the deletions.
> am running Firebird v.
> > and am using Delphi 6 client/server.
> Did you considered the posibility of not deleting those records at all,
> eventually, just marking them as unused using a "boolean" field ? If you
> have enough disk space and the right indexes this should be an option !
> Regards !
> Raul.
> -------------------------------------------------------
> Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV
> Xnet automatically scans all messages for viruses using RAV AntiVirus.
> Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate
variantele lor. Va rugam sa luati in considerare ca exista un risc de
fiecare data cand deschideti fisiere atasate si ca MobiFon nu este
responsabila pentru nici un prejudiciu cauzat de virusi.
> Disclaimer: RAV AntiVirus may not be able to detect all new viruses and
variants. Please be aware that there is a risk involved whenever opening
e-mail attachments to your computer and that MobiFon is not responsible for
any damages caused by viruses.
> To unsubscribe from this group, send an email to:
> Your use of Yahoo! Groups is subject to