Re: Why are data types size limited?

>I still maintain it's primarily to facilitate B-tree-style
>indexing and is a performance issue, like why C/C++'s integers are often
>only 32 bits.

most rdbms cut indexentries after a "reasonable" number of chars. sqlaw for example did this iirc after 16 chars. other dbms won't do it much different.

if some stupid consideres indexing a blob to be a viable option it's his personal problem. no need to limit the db features because of this.

the real problems begin when your "records" span multiple "pages". this causes drastic penaties and is not considered to be standard operation of your dbms.

if you want it you have to pay: take clobs, memos or whatever it's called. but it'll be slow as hell

ciao, jan

http://www.rsp.de/

rs&p-Dossier: Software zur Erstellung technischer Dokumentationen

              und Schriftgutes in Verwaltung und Industrie. Received on Tue Mar 21 2000 - 00:00:00 CET