That is the default and should work pretty well. You may be suffering from a related condition informally known as “cache thrashing” which was not uncommon in 4D v13 (as well as some later versions, but I haven’t kept up on what progress has been made).
If you aren’t already using it, you can monitor cache performance with the 4D Info Report component, available from 4D Tech Support. It can show you graphically where the long cache flushing occurs. HTH, Tom Benedict > On Dec 13, 2019, at 08:42, stardata.info <stard...@stardata.info> wrote: > > 20 Seconds > > Thanks > > Ferdinando > > Il 13/12/19 17:00, Tom Benedict ha scritto: >> What is the “Flush Cache every..” value in Database Settings>Memory? If >> there are ‘lots’ of records being flushed, sometimes that can take a while. >> Setting the value smaller causes it to happen more frequently, but fewer >> records, which can be more efficient. >> >> HTH, >> >> Tom Benedict >> >>> On Dec 13, 2019, at 07:39, stardata.info via 4D_Tech <4d_tech@lists.4d.com> >>> wrote: >>> >>> Hi All, >>> >>> In one my application in 4D V13.4 on Windows, in some circumstances 4D >>> client freezes, seems when in one process he must to write more records. >>> >>> During these freezes periods, the 3/4 processes launched from my >>> applications work, but the front end interface is locked and is not >>> responsive. >>> >>> After some seconds or minutes, 4D client work normally. Is possibile that >>> this is because he must to write more records ( i think around 100 - 300 >>> records )? >>> >>> Is necessary to use FLUSH BUFFER commands? >>> >>> >>> Thanks >>> Ferdinando >>> ********************************************************************** >>> 4D Internet Users Group (4D iNUG) >>> Archive: http://lists.4d.com/archives.html >>> Options: https://lists.4d.com/mailman/options/4d_tech >>> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com >>> ********************************************************************** >> ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
