[Typo3-dev] Data integrity.

[Karsten Dambekalns]

Hi Arne.

Arne Skjaerholt wrote:
>> But keep in mind that this *will* have a speed impact. :)
> Huh? Last time I looked at benchmarks InnoDB was faster than MyISAM,
> seeing how it supports row level locking instead of table (or was it
> memory page? can't remember) locking.

Well, at least when inserting large amounts of data, it is slower. I did
some testing in December, and using InnoDB increased run time for a script
of mine from under 3 minutes to over 40. Yes, three to fourty.

This was a rather special thing, though, doing only inserts (thousands of
them). And the bottleneck was disk I/O, with some InnoDB parameters tuning
this would be improvable, I'd say.

Karsten
-- 
Karsten Dambekalns
TYPO3 Association - Active Member
http://association.typo3.org/