Normal Topic RAM and client-server (Read 873 times)
johnbits
Member
*
Offline


No personal text

Posts: 41
Joined: Dec 25th, 2003
RAM and client-server
Mar 29th, 2004 at 4:13pm
Print Post Print Post  
We are in the process of a complete multi-office computer system change with a planned use of Microsoft Server and Citrix to allow on-line live access to applications from all workstations at all locations. Since Sesame requires a copy running at each workstation, my primary focus is on what are practical considersations of RAM for the workstations and the server? Since Sesame's speed is RAM-based, do the workstations require larger amounts of RAM, only the server in a client-server situation, or both?
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: RAM and client-server
Reply #1 - Mar 29th, 2004 at 4:34pm
Print Post Print Post  
Generally: the more the better. But clients need far less RAM than do servers. For big applications or lots of users, the server will take advantage of all the RAM you can afford. Clients only need "big RAM" when using the Table View (Shift-F6) and when generating very large reports.

Also, you mention that Sesame needs to have a copy of the executable on every box. Sesame will run fine from a shared directory on a networked server. There is no need for a copy on every box. You can put the executable in a directory on your "file server" and share that directory without impinging on Sesame client/server or standalone operation.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
johnbits
Member
*
Offline


No personal text

Posts: 41
Joined: Dec 25th, 2003
Re: RAM and client-server
Reply #2 - Mar 29th, 2004 at 9:48pm
Print Post Print Post  
Mark,

Thank you very much for your answer. For better understanding: assume new equipment therefore available options for fast workstation and fast server power selections.
1. Under client-server operation, what effect (if any) on peformance does having a copy of Sesame on workstations vs. sharing a copy on the server have?
2. If a fast workstation does have an effect, for what types of operations will it apply?
3. If it is a "depends on...." answer...at what point (number of simultaneous users, for example) would the local vs. shared option improve performance?
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: RAM and client-server
Reply #3 - Mar 29th, 2004 at 11:02pm
Print Post Print Post  
Be very careful here, you are mixing client/server operation with file sharing of the executables. These are two very different things.

In client / server operation a copy of sesame is running on machine A. Sesame (no matter what hard drive it was read from) is running on machine B. A and B talk to each other about your application.

In file sharing, a copy of the Sesame executable is sitting on a harddrive on machine A. Machine B copies that executable through the network to its own memory and executes it on its own CPU.

Neither of these two models has any bearing on the other.

Quote:
1. Under client-server operation, what effect (if any) on peformance does having a copy of Sesame on workstations vs. sharing a copy on the server have?


The cost of file sharing Sesame executables is merely the time it takes to copy the executable through the network to your local CPU when Sesame first starts up. The benefit is that when you upgrade Sesame you only have to upgrade one computer - everyone else gets their copy from there always.

Quote:
2. If a fast workstation does have an effect, for what types of operations will it apply?


Having fast graphics and a fast processor will enable the client's user interface to draw more quickly. Having a lot of memory will help with the Shift-F6 table view (or really super large table view subforms), and with generating large reports. Having a fast CPU on the client will help SBasic run faster and compile faster. But all of the really memory / CPU heavy operations (searching and sorting) are done by the server. If you watch client / server memory usage in task manager this becomes immediately obvious. The client will rarely exceed 10 Meg of memory usage. The server often need quite a bit more than that.

Quote:
If it is a "depends on...." answer...at what point (number of simultaneous users, for example) would the local vs. shared option improve performance?


Here is where client/server and file sharing are getting mixed together. The number of users sharing the same sesame executable will have little affect on the client/server performance. Client / Server performance will be based purely on the number of clients, the size of their applications, the speed of your network, and the operations they perform on the applications. This is true whether they are executing a copy of Sesame that is on their local harddrive, or are accessing a copy of the executable on a networked harddrive.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
johnbits
Member
*
Offline


No personal text

Posts: 41
Joined: Dec 25th, 2003
Re: RAM and client-server
Reply #4 - Mar 30th, 2004 at 1:05pm
Print Post Print Post  
Thank you very much, Mark!

Your explanation was excellent and really answered my questions about software/hardware optimization (always a question I have in database development as well as purchase/ system design recommendations).

John
  
Back to top
 
IP Logged