Subject Re: [firebird-support] sweep taking a long time
Author Alexandre Benson Smith
Richard Mace wrote:

>I am running a sweep using ibconsole, on a database as listed below,
>which is running firebird 1.00:
>Here is the spec of the server its running on.
>Hardrive: 40gb
>CPU: Intel 850mhz
>RAM: 256mb
>OS: Win 2k Prof
>Uptime: 10 weeks
>Firebird v1.0
>The Database is 34.5gb in total and the drive is partitioned, the DB
>is stored on the second partition which is 35gb.
>The IBServer.exe process is currently using between 70% and 90% and
>the memory usage has stayed at 12,996k.
>Its been running for 49hours now, any ideas how long a sweep should
>take or whether these is a quicker way of reducing the size of it?
>there is only 94mb free space on this partition currently.
>Also the applications that normally write to the database are not
>running whilst the sweep is in process.
>Thanks in advance
>Richard Mace

Sweep will not shrink the database size, it will remove unecessary
record version, so new updates/inserts could use that space. but the
size will not shrink.

The only way to reduce a database size is to make a back-up/restore cycle.

If you have a lot of duplicates in indices than the sweep will be slow.
To solve it you have two options, remove the bad index or make it
composit adding the PK of the table to the index.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil