Subject Re: [firebird-support] how to reduce the file size of the database after large amount of deletes ref/eDN8072730811
Author Svein Erling Tysvaer
Dimitry Sibiryakov wrote:
>> On 27 Sep 2006 at 12:12, Dennis wrote:
>> An application produces sales from pos terminals. Once a month I pack the
>> sales grouping by day in order to reduce the amount of records. Is there any
>> way to reduce and file size of the database to be smaller and faster?
>> I found a way backing up and restoring the database. Any other
>> suggestion?
> Give up. Next month DB will be the same size so what the purpose?..

What you could do, is to pack the sales once a day rather than once a
month. Normally, it isn't file size that makes an application slow,
rather it is queries, indexes and poor transaction handling. Make sure
your queries are efficient and use appropriate indexes, avoid huge gaps
between the oldest and next transaction and Firebird normally behaves
very nicely. As Dimitry wrote, there isn't much point in reducing the
file size.