headers
rooftop99 | 10 Oct 13:22

4D 2004.7 Server Memory Usage

Hi All,

I have read through the many posts about cache and memory in the NUG,  
however it doesn't appear there are any definitive guidelines on how  
high to set the Cache in a 4D 2004.7 server configuration.  Is there  
anyone from 4D (the company) that can chime in and let us know how to  
determine cache settings for optimal client/server performance?  That  
would be very helpful.

Also, in my server preference settings it list physical memory at   
2048 MB, however our server has 4 GB.  Am I misinterpreting this or  
does 4D sever 2004.7 only address 2 GB of RAM?

Thanks to all!!
Kirk
**********************************************************************
4D Server v11 SQL has arrived!
Buy it NOW at http://store.4ddepot.com

4th Dimension Internet Users Group (4D iNUG)
FAQ:  http://www.4d.com/support/faqnug.html
Archive:  http://dir.gmane.org/gmane.comp.lang.inug-4d.tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
Post: mailto:4d_tech@...
Options: https://lists.4d.com/mailman/listinfo/4d_tech
**********************************************************************
Permalink | Reply |
headers
Michael Kaye | 10 Oct 13:41

Re: 4D 2004.7 Server Memory Usage

> I have read through the many posts about cache and memory in the  
> NUG, however it doesn't appear there are any definitive guidelines  
> on how high to set the Cache in a 4D 2004.7 server configuration.   
> Is there anyone from 4D (the company) that can chime in and let us  
> know how to determine cache settings for optimal client/server  
> performance?  That would be very helpful.

There is no definitive advice as everyone has here seems to have their  
own opinion. If you search the archives you will see what I mean.  
Probably the best way is to choose a setting and to experiment on how  
it affects performance.

Sure others can offer up their own opinions and thoughts.

> Also, in my server preference settings it list physical memory at   
> 2048 MB, however our server has 4 GB.  Am I misinterpreting this or  
> does 4D sever 2004.7 only address 2 GB of RAM?

4D is a 32 bit app so will only address a maximum of 2gb of RAM

M.

On 10 Oct 2008, at 12:24, rooftop99@... wrote:

> Hi All,
>
> I have read through the many posts about cache and memory in the  
> NUG, however it doesn't appear there are any definitive guidelines  
> on how high to set the Cache in a 4D 2004.7 server configuration.   
> Is there anyone from 4D (the company) that can chime in and let us
(Continue reading)

Permalink | Reply |
headers
David Dancy | 10 Oct 15:29

Re: 4D 2004.7 Server Memory Usage

Kirk

The problem with cache settings is that it's really hard - read, next
to impossible - to make a recommendation of any sort without studying
your database in detail. In addition, if your database is installed in
more than one place, you may find that it needs different cache
settings in each instance. The _only_ way to find out what settings
are needed is to experiment with your specific setup. You should try
to replicate "live" conditions as much as possible, including numbers
of processes running on the server, because it's quite possible to
have one configuration that works really well in your
development/testing system which has abysmal performance when deployed
live.

That said, you can paint broad brush strokes and say things like:

* large cache is good - although "large" is a somewhat flexible term,
relative to the (free) memory on the computer, the version of the OS,
the size of your data file, and so on
* too much cache can destroy performance because when it fills up the
database has to write lots of data to disk
* too little cache can mean that the system is cramped for room and
performance will suffer there as well
* somewhere in between "too little" and "too much" there's a happy
medium, but as your database grows you may need to re-evaluate where
this lies

Sorry to be less-than-helpful!

David
(Continue reading)

Permalink | Reply |

Gmane