Geoff wrote:

<SNIP>

> Try and design your tables so that field sizes are kept to a minimum.
> Dont use fields with large VARCHAR definitions, store such values in
> blobs which will be loaded separately and only when required.

</SNIP>

Hi,

When i read this a couple of questions dive up.

1. How large is large?
100?
1000?
10000?
60000?


2. At which size should I use a blob instead of a VARCHAR?


3. Why is a blob field better than a large VARCHAR?


Best regards,
Jörg Schiemann