pg.ddx.io  University INGRES on Usenet (1985-1995): threads about Berkeley INGRES, QUEL and EQUEL from comp.databases.ingres, comp.databases and net.database  
help / color / mirror / Atom feed
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. |
|--------------------------------------------------------------------------|







view thread (17+ messages)  latest in thread

Message-ID: <MAL.95Nov30090944@mermie>
Permalink:  ../MAL.95Nov30090944@mermie/

 · 


This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox