[TYPO3-dev] BLOBs considered harmful

[Dmitry Dulepov]

Hi!

Martin Kutschker wrote:
> "Only" if you have deleted rows in the table. If you never delete rows 
> or always optimize after a delete you have full write speed :-)

Nope. I watched myisam table on a server with constant read-write, 
hundreds per second (~700tps). MySQL locks table all the time. If once 
mysql process writes there, all others appear as "Locked" in "show 
processlist". It is different with innodb: nothing is locked, 
INSERT/UPDATE/SELECT run at the same time. I do not have any "LOCK TABLES".

Dmitry.
-- 
"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)