Subject Re: [IB-Architect] Re: New feature request (thread priority)
Author Dmitry Kuzmenko
Hello, Markus!

sc_mtnbkr@... wrote:
> I doubt raising the priority of sweep/garbage
> threads would yield good side effects for a
> database under heavy transaction load. It probably
> wouldn't make a difference on a single user or low
> load system.

I have already seen that low priority sweep is useless. Read my two posts

that describes the problem. 45 minutes to sweep 10K records in a single-user
environment is TOO MUCH.
Since gbak does not have option -g by default, DBA will wait forever to backup
50-60 megabytes database, if there were frequent updates and deletes.

The main hit of setting sweep tread priority to low was to prevent heavy
load during sweep, as I understand. Now low sweep priority is a head pain for DBA.

Dmitry Kuzmenko, Epsylon Technologies.