[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

803.0. "RDB VAXcluster Locking vs SQL/net" by PJWL::LAMB (Peter Lamb - GSG Santa Clara) Tue Nov 20 1990 07:03

Hello,

I have a customer that is trying to decide between two different configurations
(esentually RISC vs VAX)  from a purly performance point of view could
someone please let me know which way they would recommend??

Configuration A is 4 VAXstation 3100 model 76 workstations clustered with
a VAX 6000/420.  The data would reside on the 6000/420 and the workstations
would access the database using the lock manager.  The database could be either
RDB or INGRES (how does INGRES do with the lock manager these days?)

Configuration B is 4 DECstation 5000/200s connected over ethernet to a 
VAX 6000/420.  Again the database would reside on the 6000/420 under either
RDB or INGRES and the applications on the DECstation 5000/200 would use
some equivilant of SQL/net to access the remote database.

I guess what I am really looking for is just some rule of thums as to when
one configuration would beat the other.  Or better yet an indication that 
configuration A would always beat B.

Thanks in advance for any help on this!!

Sincerely,

Peter Lamb
T.RTitleUserPersonal
Name		DateLines
803.1SQL/Services is the answerMAIL::DUNCANGRdb & DTM, 2 phase knockout for OracleWed Nov 21 1990 23:287
    Why don't you use SQL/services on the VAXstation or DECstation to
    access the Rdb database on the VMS server and forget about running
    Rdb on the VAXstations remotely ?  Rdb takes out lots of locks and
    why burden the weak little VAXstations with lock traffic when you
    can probably use the SQL/services API to implement client-server.
    
    -- gerry
803.2NZOV03::HOWARDNZ: Where Digital's Week BeginsThu Nov 22 1990 06:1213
    Could you tell us more about the application.
    
    If all user access vis going to be from an X-windows device, you might
    want to consider Ingres's Windows/4GL.  This is only if this is a
    totally new site (of course) because one of your competitors might offer
    this up.
    
    The RISC systems will process faster if the application requires much
    local manipulation.  VMS will offer more functionality.  If it's just
    for displaying in a local environment (you didn't say how "long" the
    ethernet link was) then VT1300s could be the answer.
    
    Cheers, Martin
803.3my 2cents.COPCLU::BRUNSGAARDACID isn't just music and junkThu Nov 22 1990 13:5014
    Re .1
    
    And if you hook up you workstations in the net (or just accesses the
    database via DECNET name) RDB$REMOTE task-task (or Client Server)
    processes will be used and the locking will only take place on the
    SERVER.
    So you don't really need to use SQL services from VMS, just use SQL and
    acces via DECNET.
    
    Re .2 The Ingres/windows/4gl is very promising, but I wouldn't bet my
    customers project on a V1 product...
    
    The pesimist,
    Lars