It also depends on size of cache. How big is cache and how much me memory on machine
On Fri, Dec 13, 2019 at 11:42 AM stardata.info via 4D_Tech < [email protected]> 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 < > [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] > ********************************************************************** -- ----------------------------------------------------------------------------------------- Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 Informed Solutions, Inc. Brookline, MA 02446 USA Registered 4D Developer Providers of 4D, Sybase & SQL Server connectivity https://www.informed-solutions.com ----------------------------------------------------------------------------------------- This message and any attached documents contain information which may be confidential, subject to privilege or exempt from disclosure under applicable law. These materials are intended only for the use of the intended recipient. If you are not the intended recipient of this transmission, you are hereby notified that any distribution, disclosure, printing, copying, storage, modification or the taking of any action in reliance upon this transmission is strictly prohibited. Delivery of this message to any person other than the intended recipient shall not compromise or waive such confidentiality, privilege or exemption from disclosure as to this communication. ********************************************************************** 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] **********************************************************************
