From: kraehe@bakunin.hb.north.de (Michael Koehne) Subject: Re: ORACLE, MINI-SQL, INGRES Comparison Date: 1995/11/14 Message-ID: X-Original-Message-ID: #1/1 X-Deja-AN: 119354904 references: <482700$t5i@carbon.cudenver.edu> organization: Privat UUCP followup-to: comp.databases,comp.databases.oracle,comp.databases.ingres,comp.databases.theory newsgroups: bakunin.local,comp.databases,comp.databases.oracle,comp.databases.ingres,comp.databases.theory 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