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: gainer@gainer.engr.sgi.com
Subject: Re: VARCHAR, WHY THE 2000 Character Limit ??
Date: 1995/11/30
Message-ID: <49kqil$db@fido.asd.sgi.com> (raw)
References: <49794h$pof@carbon.cudenver.edu>
<49dj7c$11m6@locutus.rchland.ibm.com>
<enduser-2911951505120001@dial-cup1-6.iway.aimnet.com>
<MAL.95Nov30090944@mermie>
In article <MAL.95Nov30090944@mermie>, Michael Leo <mal@winternet.com> wrote:
>In article <enduser-2911951505120001@dial-cup1-6.iway.aimnet.com> enduser@enduser.com (EndUser) writes:
>
>>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.
He is just being a dufus. From his comments it is clear he has not
done much BLOB work.
Oracle has just about the worst BLOB support of any of the big 3 RDBMS
vendors. Informix and Sybase aren't too bad but upstart DB2/unix 2.1 is by far
the best. I don't have the time or inclination to post a feature-by-feature
comparison but I have looked at these products and there is a clear winner.
Frankly, I'd be astonished if DB2/unix 2.1 didn't absolutely cream Oracle
in BLOB manipulation speed *and* function.
Pat