As Arnaud mentioned: > There is no "best settings" but "settings for each situation" and it's not > easy to evaluate.
This is very true. For a proper recommendation we would need to know more details, such as: * How big is the data file? * How big are the indexes? * 64 bit 4D Server or 32 bit? You already said that your machine is limited to 4GB of installed RAM, which means you are severely limited by hardware... However, if (for example) your data file is less than 1GB and your indexes even smaller than you have plenty of physical RAM. It all comes down to the details. As a blanket recommendation, do not exceed 50% of installed RAM when setting your maximum cache value. Kind Regards, Tim PENNER ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
