Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server

In article <3356AA08.1ABC@strengur.is>, Sveinn Sveinsson <svenni@strengur.is> writes: > Pablo Sanchez wrote: > > > > In article <0v8awLAcPRVzEwpS@smooth1.demon.co.uk>, David Williams <djw@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 this amount 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@pager.sgi.com --------------+-----------------+-------------------------------------------- pablo@sgi.com ... when mailing me, place "not spam" in the Subject