Ferdinando, try setting the cache to 8gig (8000MB) that is 50% of installed RAM.
run it for a bit, see if this helps. Chip On Wed, 18 Dec 2019 17:30:46 +0100, stardata.info wrote: > These are the specific: > > 10.385.729 Data file > > 2.466.497 Index file > > Window server 2016 64 Bit > > Xeon E5 2620 v3 > > 16 Gb ram > > Thanks > /Ferdinando/ > > Il 18/12/19 17:21, Chip Scheide ha scritto: >> Ferdinando, >> the cache holds data previously accessed, in memory. This makes future >> access to the same data faster, as the computer does not have to >> re-read the source data from the hard drive. RAM is about 1000x faster >> then a hard disk drive, (nano sec access for RAM, millisec access times >> for hard drives). >> >> Having data in the cache *is a good thing* and will increase the speed >> of your program. >> If your cache is set to be too large, you may not leave enough memory >> (RAM) for the OS or the rest of 4D, or other program(s) running on the >> same computer. This will have a compounding effect, as the OS will then >> start to use virtual memory (memory slices stored on the hard disk), >> which means EVEN MORE hard disk accessing slowing the machine further. >> >> if you are running a 32 bit OS (look under control panel -> system -> >> general (I think) ) you should see some information about the computer, >> the OS, and whether it is 32 or 64 bit. >> >> as I said in a previous message a 32 bit OS can NOT access more then >> ~3.5 gig of ram, REGARDLESS of actual RAM installed. >> >> If you are running a 32 bit OS, and have a cache setting of say 3gig >> (3000MB) you are not leaving enough for other operations. Similarly, if >> you have 32gig of RAM in a 64 bit OS, and allocate 31.5 gig of RAM to >> the cache, you are not allowing enough room for other operations. >> >> Others may have different opinions on this, >> if you are running nothing but server on the machine - I would suggest >> that you start by setting the cache to approximately 50% of available >> RAM (set it to 1.75gig under 32 bit OS, 1/2 of installed RAM under 64 >> bit). >> >> run the program for a while, see what happens. If things are good - >> leave it alone, if things are not try adjusting the size of the cache, >> again. larger if 4D is the only thing running, smaller if there are >> other programs/services running. >> >> Chip >> >> P.S. get your database running on an SSD - this increases 'hard rive' >> access speeds significantly (10x I believe). >> >> >> On Wed, 18 Dec 2019 16:58:34 +0100, stardata.info via 4D_Tech wrote: >>> Hi David, >>> >>> I come back to you to let you know that the problem that i had told >>> you about in the first post is persisting. >>> >>> Now i noticed that the cache that is occupied keep raising on every >>> interaction that the client make with the server or more specific >>> with the database. >>> >>> At this reguard i thought that closing the clients could have free >>> all the cache that was occupied but wasn't as i supposed, so even >>> closing all the clients i got still cache occupied. >>> >>> I can't find a way to free the cache and this leads me to having all >>> of it full making my software very slow. >>> >>> Hoping to hear you soon.. >>> >>> Best reguards, >>> >>> Ferdinando >>> >>> Il 18/12/19 13:29, stardata.info ha scritto: >>>> Hi David, >>>> >>>> Thanks for your indications. >>>> >>>> Ferdinando >>>> >>>> Il 18/12/19 13:03, David Samson ha scritto: >>>>> That is not such big data. Some places have 300GB of data. Maybe >>>>> your cache is set too small on 4D server. Attached is an old >>>>> document but it still explains the basics. >>>>> >>>>> David >>>>> >>>>> On Tue, 17 Dec 2019 at 18:28, stardata.info <http://stardata.info> >>>>> <[email protected] <mailto:[email protected]>> wrote: >>>>> >>>>> 10.385.729 Data file >>>>> >>>>> 2.466.497 Index file >>>>> >>>>> Window server 2016 64 Bit >>>>> >>>>> Xeon E5 2620 v3 >>>>> >>>>> 16 Gb ram >>>>> >>>>> >>>>> >>>>> Il 17/12/19 18:43, David Samson ha scritto: >>>>>> The suggestions on the NUG make sense. >>>>>> "After some hours of use the application slows down."this sounds >>>>>> like the memory is getting full. How much RAM is on the server >>>>>> and how big is your data file? >>>>>> >>>>>> On Tue, 17 Dec 2019 at 14:02, stardata.info >>>>>> <http://stardata.info> <[email protected] >>>>>> <mailto:[email protected]>> wrote: >>>>>> >>>>>> Hi David, >>>>>> >>>>>> I understand you observation, but i notice that if i restart >>>>>> the application, the problme is solved. After some hours of >>>>>> use the application slows down. >>>>>> >>>>>> Thanks >>>>>> >>>>>> Ferdinando >>>>>> >>>>>> Il 17/12/19 13:40, David Samson ha scritto: >>>>>>> This sounds like a network problem - not 4D. We had a >>>>>>> similar thing and when they restarted the network switch >>>>>>> all was OK. >>>>>>> >>>>>>> David >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> Message: 1 >>>>>>> Date: Fri, 13 Dec 2019 18:50:51 +0100 >>>>>>> From: "stardata.info <http://stardata.info>" >>>>>>> <[email protected] <mailto:[email protected]>> >>>>>>> To: Tom Benedict <[email protected] >>>>>>> <mailto:[email protected]>>, 4D iNug Technical >>>>>>> <[email protected] <mailto:[email protected]>> >>>>>>> Cc: [email protected] >>>>>>> <mailto:[email protected]> >>>>>>> Subject: Re: FLUSH BUFFER >>>>>>> Message-ID: >>>>>>> <[email protected] >>>>>>> <mailto:[email protected]>> >>>>>>> Content-Type: text/plain; charset=utf-8; format=flowed >>>>>>> >>>>>>> I notice that in some casual circumstances, 4D client of my >>>>>>> application, >>>>>>> have latency in the front end operations. >>>>>>> >>>>>>> I click, but the client is not responsive. >>>>>>> >>>>>>> After some seconds or one minute, all restart normally. >>>>>>> >>>>>>> I've noticed that before the unlock, I have one peak of >>>>>>> traffic in the >>>>>>> network. Seem that the client is stopped to wait for the >>>>>>> server response. >>>>>>> >>>>>>> Does someone have a suggestion? >>>>>>> >>>>>>> Thanks >>>>>>> >>>>>>> Ferdinando >>>>>>> >>>>>>> -- D Samson >>>>>> >>>>>> >>>>>> -- D Samson >>>>> >>>>> >>>>> -- >>>>> D Samson >>> ********************************************************************** >>> 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] >>> ********************************************************************** >> We have done so much, with so little, for so long; >> We are now qualified to anything with nothing <sigh> >> - unknown >> We have done so much, with so little, for so long; We are now qualified to anything with nothing <sigh> - unknown ********************************************************************** 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] **********************************************************************
