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 <[email protected]> > 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:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************

