On Mon, Aug 13, 2007 at 10:16:15PM -0700, Josh Berkus wrote:
> Pavel,
>
> > I did't test MySQL three years, But three years ago, MySQL rollback
> > was really, really slow.
>
> Based on recent testing I did, rollbacks are very expensive -- like 3x to 4x
> the cost of the original insert in high-concurrency environments. Also not
> always reliable (as of 5.0).
Wow, that's a serious gotcha. If there's a way to reproduce that we
should certainly let Ian Barwick of MySQL gotchas fame know about it.
--
Decibel!, aka Jim Nasby decibel@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)