Subject Re: [firebird-support] endless sweep
Author Alexandre Benson Smith
Ferda Brabenec wrote:

>Hi Alex,
>thanks for the info. The sweep finished after 5 days.
>I am a bit puzzled by the fact, that indices play such a big role in sweep
>process. Is it because they contain references to already deleted records?
>
>Regards, Ferda
>
>
Hi Ferda,

I don't remember the real reason why sweep take a long time to run if
you have a lot of duplicates, I think because the entire duplicate chain
should be reached to look for the records on the data page, I am sure
someone will jump in and explain the real reason with acuracy.

Take a look on the history, for the thread "Long running gfix - safe to
kill?" Ann has made some comments on it.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.6.1 - Release Date: 04/03/2005