Subject | Re: [firebird-support] endless sweep |
---|---|
Author | Alexandre Benson Smith |
Post date | 2005-03-10T16:14:39Z |
Ferda Brabenec wrote:
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
>Hi Alex,Hi Ferda,
>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
>
>
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