In the bigger table there are around 4 millions of records
In the memory teg the settings are so:
Calculating adaptive cache ON
Memory to be reserved for other applications and system: 128 MB
Percennt for available memory used for cache: 50%
Minimum size 100
Maximun size 100
Kepp the cache in phisical memory: Disabled
Current cache: 100mb
Flush buffer every: 15 Min
Thanks
Ferdinando
Il 01/11/2016 22:49, 4d_tech-requ...@lists.4d.com ha scritto:
Message: 1
Date: Tue, 1 Nov 2016 17:21:58 -0400
From: Charles Miller<miller.c...@gmail.com>
To: 4D iNug Technical<4d_tech@lists.4d.com>
Subject: Re: Progressive slow
Message-ID:
<cadksfq7n-truzjsd0shkdxguo02rmv5w4n29sycqxgpmhzx...@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
On Tue, Nov 1, 2016 at 4:49 PM, stardata.info<stard...@stardata.info>
wrote:
>4 GB
>
Great your cache should not be set bigger than 1024. once again how big is
data file(file size), number of records?
Cache should*NOT* be set to adaptive
Is there any other stuff running on your server machine. How are setting in
4D re cpu priotities. How long for data flush. This is something
overlooked. If you are flushing every 20 minutes it will take 20 times
longer than every minute on average, but appear to be much slower, as there
is 20 times more to be flushed. In pre v15 I always set to 1 minute. In 15
and higher I set for between 15 and 30 seconds.
Regards
Chuck
**********************************************************************
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
**********************************************************************
