Subject Re: backup very slow and how often sweep a database ?
Author Aage Johansen
Dmitry wrote:
<<
Hello, Aage!
Tuesday, December 20, 2011, 3:02:26 PM, you wrote:
AJ> Everyday i sweep the database and i backup it
AJ> gfix.exe -sweep
AJ> and just after a backup like this :
AJ> gbak.exe -B -t -v -z
...
>>

The lines starting with "AJ>" was my quote from Stéphane's email.
It's not _my_ problem :-)


That said, it seems that the only solution for
Stéphane is that he fixes his handling of
transactions (see also post from Thomas
SteinMaurer). His transactions (possibly
excepting those that are ReadOnly/ReadCommitted)
must do a COMMIT at appropriate places (and more often than "never").


--
Aage J.