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: kraehe@bakunin.hb.north.de
Subject: Re: ORACLE, MINI-SQL, INGRES Comparison
Date: 1995/11/14
Message-ID: <DI1yrq.1n0@bakunin.hb.north.de> (raw)
References: <482700$t5i@carbon.cudenver.edu>
George/Jorge (ghharrac@ouray.cudenver.edu) wrote:
: As a user of ORACLE, I am looking for information about what I consider
: to be the major RDBMS and their usage of STRUCTURES ( ISAM, CISAM, HEAP,
: HASH, ....) foreign concepts to ORACLE. How does the usage of these structures
: affect the performance of the system ? I know what theory says, but I am
: look from the users point of view. I also want information of the
: usage of ORACLE tablespace, to how Ingres and Mini-sql handle tables in
: seperate files and their manipulation. What is better, the tablespace
: concept of the 'others'?
I dont know Oracle, but I've tried to compare the free
Ingres89, the free mSQL, Informix SE and Yard-SQL.
We have a database originaly hosted on a SparcII (32MB RAM)
under SunOs Informix SE, which occupies 30 MB of filesystem
space. With Yard (a comercial SQL available for Linux)
I need a 80 MB partition to have 20% free. With mSQL
I can put it in about 27 MB, and with Ingres I'm using
C-ISAM and the same DB fits into 5 MB.
Oh my Linux box (4dx33) has 16 MB of Ram, and is now much faster
than a Sparc II under Informix because the whole DB fit
into the buffer cache !
We now have a Linux box next to the Sparc because Ingres89
is buggy when not running on a VAX or Intel.
BTW: Minerva on Sparc is a bit faster than Informix SE
and a much faster than Yard. But Ingres beets them
all.
In our environment our standart query with 6 simultan
pseudo users will need 3,2 seconds with Informix (Sparc), 4.1
with Yard (Linux), 1.8 with Minerva (Sparc), 2.2 mSQL (Linux)
and 0.7 with Ingres89 (Linux).
By Michael
--
" ceterum censeo MSDOS esse delendam " sagt der Guru und krault seinen Bart
Germany - 27721 Werschenrege 52 - +49 4292 674 - kraehe@bakunin.north.de