Dennis - I agree with you on the memory issue. However, the initial question was/is: Why are searches quick(er?) after a restart and slow down after some period of server up time. This is not/should not be a client side issue - it is most likely a cache issue...
However there is one other thing that no one has pointed out - it could be that OP's 4D code has a memory leak - i.e. the code is using memory for some action(s) and NOT releasing that memory back to 4D/system. This could also causes a restricted memory issue which could force 4D to start using the disk (virtual memory/paging) during a query. To fix this problem (memory leak) will require some code analysis, and likely some time. To insure that memory is returned (and yes I know 4D does a much better job at this now). clear the following items at the end of a process, if not when the code is finished using it. (local arrays are supposed to be cleared automagically). - arrays (set to size zero or clear variable) - sets (clear set) - named selections (clear named selection) - Lists (hierarchal especially) and Transient lists (created by Array to list) - Clear List, be sure to clear all levels of an hierarchal list) - selections - turn off On Err call, On event call On Tue, 1 Nov 2016 21:06:29 +0000, Dennis, Neil wrote: > With a 4GB machine you shouldn't use more than 2GB cache memory for > 4D server. > > You can consider a bigger/faster computer to help processing speed... > often this is the easiest to increase performance. > > If you watch the server processes when there is a slowdown or when it > starts to get slower, is the CPU, network, or disk higher than normal? > > A lot of 4D server performance can be controlled in the way that 4D > code is written. Try to figure out what the client is doing with the > server is slow. The watch pane can tell you a lot about the code that > is executing when you are seeing slowness. > > There are a lot of things that can cause slow performance... Once you > figure out what code is causing the slowness see if you can optimize > it for server. > > Neil > > > > > > -- > > Privacy Disclaimer: This message contains confidential information > and is intended only for the named addressee. If you are not the > named addressee you should not disseminate, distribute or copy this > email. Please delete this email from your system and notify the > sender immediately by replying to this email. If you are not the > intended recipient you are notified that disclosing, copying, > distributing or taking any action in reliance on the contents of this > information is strictly prohibited. > > The Alternative Investments division of UMB Fund Services provides a > full range of services to hedge funds, funds of funds and private > equity funds. Any tax advice in this communication is not intended > to be used, and cannot be used, by a client or any other person or > entity for the purpose of (a) avoiding penalties that may be imposed > on any taxpayer or (b) promoting, marketing, or recommending to > another party any matter addressed herein. > ********************************************************************** > 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:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 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:4d_tech-unsubscr...@lists.4d.com **********************************************************************