Well, the hole story is this.



It is a trade application with sales with pos machines.



When the database came bigger than 300mb, there are some lags during the
day, in precise 5-10 seconds, 3 times per day, per pos machine. We can say
that this is normal for a sql based application but too bad for pos
machines, 5 seconds it is too much. It is about 50000 records on header
table and 200000 on details table.



For this reason I made 2 databases (files) in the same branch (shop). One is
the 'main' of the branch and the other one database file 'pos' for pos
machines, these 2 databases are synchronized successfully!



Now, what I want is to delete the movements from pos database and reduce
with someway the database file to actual filesize according the records
where holds. So the pos machines will run better as the database is almost
empty.



What do you think?

Regards

Dennis





_____

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

On 27 Sep 2006 at 12:12, Dennis wrote:

>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?..

--
SY, Dimitry Sibiryakov.





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