Path: utzoo!censor!bvax!da
From: da@bvax.UUCP (Dave Sellers)
Newsgroups: comp.databases
Subject: Re: Do you like your UNIX RDBMS?
Summary: Too slow, change to something else.
Message-ID: <280@bvax.UUCP>
Date: 7 Jun 89 02:00:48 GMT
References: <9703@dasys1.UUCP> <3378@fp.sei.cmu.edu> <2907@osiris.UUCP> <114@anasaz.UUCP>
Organization: Bell Canada, Toronto, CANADA
Lines: 14

In article <114@anasaz.UUCP>, john@anasaz.UUCP (John Moore) writes:
> ]database.  Suppose you issue a query and there are 1000 matching records.
> ]Are you aware that ALL the current ESQL implementations require that you
> ]WAIT FOR THE 1000 RECORDS TO BE FOUND EVEN BEFORE YOU CAN VIEW THE 1ST ONE?
> ]Thus your client will be FORCED to wait for up to 5 minutes before he/she 
> ]gets a response from a simple query!

Well if you have to wait more than 5 seconds, there is a problem and the
RDBMS is searching the whole DB. No one will ever wait 5 MINUTES (or shouldn't).

Our Sun takes <>30 seconds to run all 60K records and only a few seconds to
extract ??? records if the optomizer (sp?) is not screwed up.

Dave