As Chuck pointed out, you may need to increase the size of your cache. The Info Report will make this evident.
Tom > On Dec 13, 2019, at 09:13, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Contact 4D Tech Support. > > Tom > >> On Dec 13, 2019, at 09:08, stardata.info <stard...@stardata.info> wrote: >> >> Hi Tom, >> >> >> How I can find this component? >> >> Thanks >> >> Ferdinando >> >> Il 13/12/19 18:06, Tom Benedict ha scritto: >>> 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 > ********************************************************************** ********************************************************************** 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 **********************************************************************