Hi

Just to get me sure.

1.
The automatic sweep function will kick in, when the gab between oldest
active transation and next transaction gets greater than 20.000
(assumming that the value is 20.000).



2.
At a customer site the gabs grows and shrinks during the day, and at
night time the gab is usually back to 1.
But sometimes the gab keeps growing.
This can be caused be:

a. A rollback ???
b. Program error (which we keep correcting).
c. More ???



3.
At this particular customer site, we have disabled the automatic sweep.
Then every night we have made a litte scheduled job, that sweeps the DB.
This normal finished in a very short time, which I think is when the
gab is 1.

But yesterday I did it manually to monitor the progress.
The gab was about 40.000, which I think was due to the fact, that the
customer was in the middle of a great update in the morning, but
choose to cancel that (rollback), because they had a busy day ahead.

I then manually ran the GFix -sweep program, and it to almost 1½ to
complete.
I was the only user attached at the time, so is this normal ?
I can do a backup - restore faster than this !





4.
We have disabled the automatic sweep, because everytime we enabled it,
the DB on our customer site crashes after a few days.
We have tried to change almost every hardware involved, upgrading
drivers etc, and made a lot of program correction.
All works without ANY problems until we enable the automatic sweep.

I do not recall the erros excatly, but they can only be solved by a
backup - restore procedure.

I havn't seen any reporting any problems with the automatic sweep
function yet, but I gets me wonder..... .......


And as far as information goes:

The DB server is running Windows 2000 on a 1,5 GHz P IV.
It has 3 SCSI HDD in a raid.
It runs ONLY as DB Server.
The Firebird version is: 1.0.0.794

The clients all use the same programs to connect (some we have developed).


Regards
Michael