[TYPO3-dev] BLOBs considered harmful

[Dmitry Dulepov]

Hi!

R. van Twisk wrote:
>> Why cannot you use mysql? Customer's wish for Oracle? Try to convince 
>> them for mysql.
>>   
> Since customers request other database systems then mysql.

I asked Martin for his specific case, not in general :)

> Specially they want to move away from myisam storage type, there is no 
> trust in myisam.
> And I for myself have had a couple of currupted tables (specially cache 
> tables, easy to re-build)
> and on my own site problems with my isam.

Cache tables work best with innodb. myisam locks the whole table when it 
wants to write to it and thus kills performance. Innodb allows 
concurrent inserts together with reads. Works much faster than myisam. 
There are other problems though (like bad "count(*)" performance and 
slower index lookup).

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