Subject Re: [firebird-support] Firebird 1.5. Please help
Author Roland Turcan
>I have un aplication with Delphi 7 + IBO 4.3A + Firebird 1.5 Final
>
>In that aplication there are um process that delete and insert one
>average of 1500 records each run time
>
>My customer execute this option several times in a day and the
>database stay so slow that the only solution is backup/restore every day.
>
>Can someone tell me if thi is normal (on FB1.5)?
>I work with Firebird since de begin and i'm very happy with it until now.
>
>Thanks in advance
>and sorry for my bad inglish.
>
>
>
Hi!

Send me:

1. Database size
2. Database page size
3. OS Platform
4. FireBird platform
5. Sweep interval
6. Do you do sweep process manually or you have sweep interval >0
7. Why you must delete or insert each run time ? Update record have
lower overhead on server, because update save only delta part of changing.

With best regards

TRoland
www.rotursoft.sk