[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

Title:DEC Rdb against the World
Moderator:HERON::GODFRIND
Created:Fri Jun 12 1987
Last Modified:Thu Feb 23 1995
Last Successful Update:Fri Jun 06 1997
Number of topics:1348
Total number of notes:5438

439.0. "Competitive point versus INGRES" by COOKIE::BERENSON (I'm the NRA) Wed Sep 27 1989 20:41

A small (or in some cases large) competitive advantage of Rdb/VMS over INGRES.
When using Dynamic SQL, Rdb/VMS allows prepared statements to be reused
across transaction boundaries.  With INGRES, you must re-PREPARE the statement
for each transaction.  This is a dramatic performance hit.

Since most interactive tools work with a database system through the
Dynamic SQL interface, this gives Rdb/VMS a big advantage.  It also explains
why INGRES' tools generate 3GL code which is then compiled, rather than
using Dynamic SQL.

Hal
T.RTitleUserPersonal
Name		DateLines
439.1Impact on Ingres Tools for RdbCSOA1::CARLOTTII hate when golf season ends :-(Thu Sep 28 1989 15:0414
>> When using Dynamic SQL, Rdb/VMS allows prepared statements to be reused
>> across transaction boundaries.  With INGRES, you must re-PREPARE the 
>> statement for each transaction.  This is a dramatic performance hit.
>> 
>> Since most interactive tools work with a database system through the
>> Dynamic SQL interface, this gives Rdb/VMS a big advantage.  It also explains
>> why INGRES' tools generate 3GL code which is then compiled, rather than
>> using Dynamic SQL.

What are the implications of this for customers using Ingres Tools for Rdb?



Rick C
439.2Ask in the tools conferenceCOOKIE::BERENSONI'm the NRAMon Oct 02 1989 19:4011
Ask in the INGRES TOOLS conference, but I will bet that (at least
currently) it means that applications developed with the INGRES TOOLS do
not take advantage of this Rdb/VMS capability.

Since we are involved in both cooperation (INGRES TOOLS, ULTRIX/SQL) and
competition (VMS Databases) with RTI, we are always in a funny
situation.  For example, RTI has been made aware of the impact this
particular behavior of theirs has on some software we want to port from
VMS to Ultrix.  So, we hope they will fix it sometime soon.  Of course,
once they fix it for ULTRIX/SQL, the fix will also become available for
INGRES on VMS, negating this competitive advantage.  Sigh.