Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!iuvax!cica!tut.cis.ohio-state.edu!ucsd!nosc!chip!ncr-sd!otl!stevec
From: stevec@otl.SanDiego.NCR.COM (Steve Chaput)
Newsgroups: comp.databases
Subject: Server performance
Message-ID: <2358@ncr-sd.SanDiego.NCR.COM>
Date: 17 Jan 90 00:25:51 GMT
Sender: news@ncr-sd.SanDiego.NCR.COM
Reply-To: stevec@otl.SanDiego.NCR.COM (Steve Chaput)
Distribution: usa
Organization: NCR Corporation, Rancho Bernardo
Lines: 20



I have a question concerning Sybase configurations.  In a 
hypothetical situation, we have a Sun dedicated as a Sybase 
4.0 SQL Server on a LAN.  Assume that we have tuned our server 
for optimum performance.  However the client application 
accessing the server requires greater performance.  The client 
application accesses ATM machines and performs single row 
updates, inserts, and fetches on a very large table (350MB).  
We want to dedicate another identical Sun to share the server 
requests to increase client performance.  We are willing to 
modify the client application and partition the data between 
machines. Replication of the data is undesirable. 

How can we decrease the time it takes the client to process n 
transactions utilizing the additional machine ?  How much of a 
change could be expected ?

How would other database vendors (Ingres, Oracle, Informix...) 
handle this situation.