pg.ddx.ioUniversity INGRES on Usenet (1985-1995): threads about Berkeley INGRES, QUEL and EQUEL from comp.databases.ingres, comp.databases and net.database
From: mal@winternet.com
Subject: Re: VARCHAR, WHY THE 2000 Character Limit ??
Date: 1995/11/30
Message-ID: <MAL.95Nov30090944@mermie> (raw)
References: <49794h$pof@carbon.cudenver.edu>
<49a8b8$546@news1.wolfe.net>
In article <enduser-2911951505120001@dial-cup1-6.iway.aimnet.com> enduser@enduser.com (EndUser) writes:
>
>wrong. the varchar 2000 is actually upgraded from earlier sizes of 255.
>if you want to store large, gigabytes of chars, use long and long raw in oracle.
I believe even University Ingres used the 2K page size. I've used
commercial Ingres since 3.x, and it always had 2K page size.
I don't find any references to the 512 pages size in the Stonebraker
book "The Ingres Papers" either.
>there you will find a more than adequate facility. in other words. comparing
>like below is incorrect since you are looking in the wrong place for the answer.
>do not compare the datatypes.
>
>also, db2, ingres, and informix fall far short in the speed with which
>theyhandle
>large character fields.
>
How did you do this comparison? Define "large". Please be more
specific. I don't understand what you are comparing.
Cheers,
|--------------------------------------------------------------------------|
| Michael Leo | The Ingres FAQ is at ftp.adc.com, /pub/ingres. |
| York & Associates, Inc.| Also check out /pub/ingres/utilities/NAIUA for |
| Minneapolis, MN, USA | the NAIUA Tool Kit. Lastly, access all this via|
| (612) 921-8083 (voice) | WWW at http://www.adc.com/ingres/ing-top.html. |
| mal@winternet.com | All constructive suggestions/criticism welcome. |
|--------------------------------------------------------------------------|