Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Date: 1997/04/18
Message-ID: <5j6o1v$14s_at_mew.corp.sgi.com>#1/1
In article <3356AA08.1ABC_at_strengur.is>, Sveinn Sveinsson <svenni_at_strengur.is> writes:
> Pablo Sanchez wrote:
> >
> > In article <0v8awLAcPRVzEwpS_at_smooth1.demon.co.uk>, David Williams <djw_at_smooth1.demon.co.uk> writes:
> > > >I can do a *moderate* comparison between Informix and Sybase (32 bit
> > > >port):
> > > >
> > > >Sybase 11.0.X Informix 7.22
> > > >------------- -------------
> > > >o ~2 gig max for data cache o 1 gig max for data cache
> > > >
> > > > Drawback Informix. With a smaller data cache there's less data you
> > > > can cache in memory.
> > >
>
> Primarily you would use this amount of memory for data warehouses
^^^^^^^^^ I think you'll find OLTP environments that will use thisamount of memory. Quite a bit in fact.
>
> On a HP9000/K400 with four CPUs and data striped across several
> disks I have seen the overall I/O throughput measured by iostat
> during a sequential scan exceed 24MB/sek, which I wouldn't call
> a bottleneck.
>
Are we talking online or XPS? 24MB/sec is okay... I mean, it's not lumbering but it's not that impressive.
-- Pablo Sanchez | wk: 415.933.3812| pg: 800.930.5635 -or- pablo_p_at_pager.sgi.com --------------+-----------------+-------------------------------------------- pablo_at_sgi.com ... when mailing me, place "not spam" in the SubjectReceived on Fri Apr 18 1997 - 00:00:00 CEST