[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

894.0. "Ingress Tools Performanc" by DOD2::ROBERTS () Wed Mar 20 1991 19:50

    How does INGRESS tools talk to Rdb/VMS.  I know in the past they used
    callable RDO.  
    
    Do they now talk DSRI directly?  
    
    Is the performance of these tools on Rdb/VMS match the performance you
    would get using the INGRESS Database?
    
    I have an opportunity to sell them on Rdb/VMS but I have heard
    rumblings that the performance of these tools is a real dog?
    
    Any input...
    
    Lisa
T.RTitleUserPersonal
Name
DateLines
894.1NOVA::INGRES_TOOLS_FOR_RDBMBALDY::LANGSTONassimpleaspossiblebutnotsimplrWed Mar 20 1991 21:161
Press KP7 to add the conference: NOVA::INGRES_TOOLS_FOR_RDB.
894.2SQL, not RDOBROKE::THOMASSat Mar 23 1991 01:248
    The Ingres Tools for Rdb communicate with Rdb using SQL, not RDO, 
    not DSRI.  The Ingres Tools do not run slower with Rdb than they do
    with Ingres.  And since Rdb is faster than Ingres, one would assume
    that they run faster on Rdb.
    
    Why would you _not_ consider selling them Rdb?  If they are displeased
    with the performance of the Ingres Tools, then perhaps you should sell
    them a different tool kit.
894.3One Attach for many users ?TAV02::ARIE_LArie LevySun Mar 24 1991 12:1310
I'll appreciate further explanation,

INGRES ver 6 works in a Multi_server architecture.

Does it mean that by using INGRES tools for Rdb, You can have many Rdb users
Using one attach to the database, done by INGRES server ? 

Thanks,

Arie Levy
894.4Dynamic SQLTRCO01::MCMULLENKen McMullenTue Apr 02 1991 17:4621
    Ann,
    
    Your statement re "Ingres Tools do not run slower with Rdb than they do
    with Ingres" is a little misleading. True the Tools produce application
    code that compiles and run. But in an Rdb environment they are not able
    to make use of the Ingres catalogue during run time. The implementation
    of the "Ingres catalogue" within the Rdb database is not the best
    performer at run time. Ingres has said they have a lot of "tuning" to
    do in that area. 
    
    The database calls to Rdb are via dynamic SQL, which has a little extra
    overhead on the database calls. In a totally Ingres environment, the
    calls are compiled and optimized before the call.
    
    Reality also says, unless it is a large database Rdb and Ingres will
    most likely perform equally. Therefore a total Ingres tools/database
    verses Ingres tools/Rdb may perform a little better due to the above.
    
    Hopefully a few cycles/IOs will not matter in most customers scenarios.
    
    Ken M