* Hugh Williams > > Both log_enable 2 & 3, enable row by row auto commit which avoid deadlocks, 2 > then has transaction logging disabled and 3 has logging enabled so I don’t > see how you are expecting both approaches to be combined ? It is the row y > row auto-commit that makes both approaches slower than if it was off ...
I didn't understand the settings, and so didn't know if they could be combined. I just wanted you to explain, which you now did. Thank you, that helps. :-) I found that I could make operations after the delete faster again by running db.dba.vacuum() in iSQL. --Lars M. http://www.garshol.priv.no/tmphoto/ http://www.garshol.priv.no/blog/
