Subject Re: Highly variable text data
Author Adam
If you can use varchar, it is the better option. It has less overhead
and is generally much easier to work with. There are however times
where you may need to use a BLOB.

You have said you don't need it indexed, but even if you do need it
indexed, it actually is quite easy to do using a smaller field. All
you do is store some hash of the URL and index that. The hash will
not guarantee uniqueness (so you still need an "and url='www.'" in
your where clause somewhere), but it will have a pretty good
selectability, and you can find some hashing algorithms with pretty
low overheads.

We have to use blobs in certain circumstances, but we try to avoid
them where possible.


--- In, "Chad Z. Hower aka Kudzu"
<chad-jm@h...> wrote:
> I have some data like a URL That will vary in size. I don't need to
index it
> or other. Would it be better as a memo insetad of a varchar? A
varchar will
> always use 250 bytes (or whatver) I set it at ,while a memo will be
> dynamic in use no? Or doesit not matter in sizes such as 250?
> With a varchar I have to say 250, even though most will be < 80.
> --
> Chad Z. Hower aka Kudzu
> "Programming is an art form that fights back"
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 265.6.10 - Release Date: 1.10.05