Re: Questions?

GEGARCIA@benavides.com.mx (=?iso-8859-1?Q?Gerardo_Garc=EDa?=) wrote: :We are testing Informix & Metacube on NT and Unix : :We have knowlegde of Microsoft SQL Server and we have some questions ...snip of answered question... :2: :Its posible to have the next results : :Select sum(Units) as Unit from SevenmillonRecordTable : :MS SQL Server INFORMIX 7.22 INFORMIX 7.23 :Alpha 4100 Alpha 4100 Intel :4/200 :768 MB RAM 1GB RAM 768 MB RAM : :10 secs 3.5 min 4 min So you claim that MS SQL Server is able to sequentially read this table at the rate of 700.000 rows a second. Sounds a little fast to be true. How large are each row? May be the result (or significant parts of it) where cashed due to some prior operation? The Informix results you indicate would be on the order of 30.000 rows per second. More believable. Or was there realy some where clause in which case new kinds of optimisation comes into play, particularly the need for update statistics, but others as well. Overall the Informix engines are supposed to be at least as fast or faster than MS SQL Server, but there are a lot of variables and the relative performance of individual statements may of course vary a lot. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org