[TYPO3-dev] BLOBs considered harmful

["Marc Wöhlken [quadracom]"]

Martin Kutschker schrieb:

> TYPO3 itself doesn't use BLOBs that way. It simply abuses them. In fact
> most of them could even be VARCHAR(255) because they don't need to be
> very large.

This may be true for most pratical situations but in THEORY these fields
have to be large as the may contain wast amounts of ids. Blobs are
mostly used as naiv implementations of n-m- relations :-(

> Anyway, as those fields are not sorted it doesn't matter if the DB can
> or cannot sort them.
O.K. according to your post sorting isn't a matter. How about searching
/ comparison using the like operator?

CU
 Marc

-- 
...........................................................
Marc Wöhlken

Quadracom - Gottschall, Proffe & Wöhlken

Fedelhören 45a                 WWW: http://www.quadracom.de
D-28203 Bremen                E-Mail: woehlken at quadracom.de
______________             PGP-Key: http://pgp.quadracom.de