Chip,
The issue regard one process, but you must consider that i close and
open the process every time.
The same process after restarted the application work fine, but if i
open the process after many time, that the application work, the same
process is more slow.
Thanks
/Ferdinando/
Il 04/11/2016 20:00, [email protected] ha scritto:
Message: 2
Date: Fri, 4 Nov 2016 10:37:41 -0400
From: Chip Scheide<[email protected]>
To: 4D iNug Technical<[email protected]>
Subject: RE: Progressive slow
Message-ID:<[email protected]>
Content-Type: text/plain; charset=us-ascii
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
**********************************************************************
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]
**********************************************************************
