InnoDB checks UNIQUE and FOREIGN KEY constraints row-by-row

Hi For my first post here, let me speak about this issue which bogged us down a few time ago : InnoDB checks UNIQUE and FOREIGN KEY constraints row-by-row It may sound trivial, but it means that unique and foreign key constraints aren’t transaction safe. But, when using some ORM like hibernate, it’s pretty easy [...]