🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: net.database
Article #92

INGRES and ORACLE

#92
From: Mike Tiberio
Date: Wed, 21 Aug 1985 14:41
11 lines
1219 bytes
We have used INGRES here at the Center for Seismic Studies for over three
years. Originally we used the Berkeley version, now we use RTI. When I 
approached a buddy at another firm that uses ORACLE, with the problem of 
how to do an outer join, I found ORACLE had an easy to use extension of the 
select (=retrieve) command. RTI in their applications notes give an example 
of how to do it, however their method is much more convoluted. By the way we 
timed RTI vs Berkeley INGRES and found a three way join to be 60 times faster 
for RTI. A sort was 2 times faster for RTI and a replace was slightly slower 
for RTI. These tests were done about 2 years ago.

seismo!tiberio
Technical Details
Message-ID: <25@seismo.CSS.GOV>
Path: arc1-ca.pugleaf.net!utzoo!linus!gatech!seismo!tiberio

Show Full Headers
Complete Article Headers
Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP
Posting-Version: version B 2.10.3 4.3bsd-beta 6/6/85; site seismo.CSS.GOV
Path: arc1-ca.pugleaf.net!utzoo!linus!gatech!seismo!tiberio
From: tiberio@seismo.CSS.GOV (Mike Tiberio)
Newsgroups: net.database
Subject: INGRES and ORACLE
Message-ID: <25@seismo.CSS.GOV>
Date: Wed, 21-Aug-85 10:41:53 EDT
Article-I.D.: seismo.25
Posted: Wed Aug 21 10:41:53 1985
Date-Received: Fri, 23-Aug-85 06:06:19 EDT
Organization: Center for Seismic Studies, Arlington, VA
Lines: 11
Keywords: outer join