| Subject | Re[2]: [firebird-support] sweep start & running |
|---|---|
| Author | Dmitry Kuzmenko |
| Post date | 2013-01-14T14:30:20Z |
Hello, Nick!
Monday, January 14, 2013, 5:52:49 PM, you wrote:
NU> if 2 processes both see a gap > 20000 will that result in 2 sweeps running
NU> at the same time?
transaction start is serialized, i.e. no 2 transactions can start at
the same time. So, auto-sweep can not run 2 times at once.
Only first transaction start, that will discover "sweep interval",
will initiate auto-sweep (if it is not turned off by sweep interval =
0).
--
Dmitry Kuzmenko, www.ib-aid.com
Monday, January 14, 2013, 5:52:49 PM, you wrote:
NU> if 2 processes both see a gap > 20000 will that result in 2 sweeps running
NU> at the same time?
transaction start is serialized, i.e. no 2 transactions can start at
the same time. So, auto-sweep can not run 2 times at once.
Only first transaction start, that will discover "sweep interval",
will initiate auto-sweep (if it is not turned off by sweep interval =
0).
--
Dmitry Kuzmenko, www.ib-aid.com