I have check the indexes, there only these that the application wants.

I will delete only the records and I will check the speed. I will inform you
about my tests.



Thank you guys for your time.



Dennis





_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Svein Erling Tysvaer
Sent: Wednesday, September 27, 2006 1:15 PM
To: Firebird-support
Subject: Re: [firebird-support] how to reduce the file size of the database
after large amount of deletes ref/eDN8072730811



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.

HTH,
Set





[Non-text portions of this message have been removed]