| Subject | Re: [firebird-support] how to reduce the file size of the database after large amount of deletes ref/eDN8072730811 |
|---|---|
| Author | Svein Erling Tysvaer |
| Post date | 2006-09-27T10:15:01Z |
Dimitry Sibiryakov wrote:
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.
HTH,
Set
>> On 27 Sep 2006 at 12:12, Dennis wrote:What you could do, is to pack the sales once a day rather than once a
>> 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?..
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.
HTH,
Set