Path: utzoo!mnetor!uunet!lll-winken!lll-tis!ames!pasteur!postgres!larry
From: larry@postgres.uucp (Larry Rowe)
Newsgroups: comp.databases
Subject: Re: Quel vs SQL in Ingres 5.0
Message-ID: <2239@pasteur.Berkeley.Edu>
Date: 9 Apr 88 04:49:15 GMT
References: <4350@ihlpf.ATT.COM>
Sender: news@pasteur.Berkeley.Edu
Reply-To: larry@postgres.UUCP (Larry Rowe)
Organization: Postgres Research Group, UC Berkeley
Lines: 10
Keywords: quel, sql, ingres

There is a performance penalty to using SQL in INGRES 5.0 -- the time
to translate from SQL to QUEL.  This time is negligable for most
applications, but it may be noticable in high xact rate applications
where the xacts are one-table queries.  The reason is that a one-table
query ought to take 50-100 msecs on a VAX 780 class machine.  The extra
translation probably takes 5 msecs so it can slow things down by 5-10%.

This issue is moot with INGRES 6.0 which has a native SQL parser in the
backend.  I believe 6.0 is in beta release now and is expected to be
released for production use shortly.  Check with your RTI sales rep.
	larry