if you already clear everything then it is likely a cache issue other replies in this thread should give you the info you need to try to resolve that problem.
On Mon, 7 Nov 2016 21:39:23 +0100, stardata.info wrote: > Chip, > > The process do always the same operations. > The user open the process, do a series of query and close the process. > There is a counter that show the progression of the work, and after > some times the count down is slow. > > The application run with 4D V13.3 is on client server mode, and is compiled. > > Thanks > > Ferdinando > > Il 07/11/2016 21:00, 4d_tech-requ...@lists.4d.com ha scritto: >> Message: 4 >> Date: Mon, 7 Nov 2016 11:20:54 -0500 >> From: Chip Scheide<4d_o...@pghrepository.org> >> To: 4D iNug Technical<4d_tech@lists.4d.com> >> Subject: RE: Progressive slow >> Message-ID:<20161107112054884968.76335...@pghrepository.org> >> Content-Type: text/plain; charset=us-ascii >> >> It is likely then that one or more cache settings need to be changed. >> >> although there is one more thing that could be a cause of a memory leak >> - Objects (not sure which version of 4D you are using). I have not >> worked with these yet, but I can see where they could be a possible >> memory leak. >> >> Other than that - cache settings and/or cache flushing. >> >> if the flush rate (time between flushes is too long) when the disk cash >> *is* flushed it could take some time, and as I remember this is a >> locking action (i.e. it stops other activities until it completes). >> >> --- >> Are you*sure* that it is the query that is slow? >> could it be that you are loading progressively more data, and so the >> process looks like it is slowing down. >> >> i.e. >> - you do a query >> - get some result records >> - do something with them, BUT forget to set a flag that the action has >> already occurred. >> Later >> - you do the same query >> - get the original result records + new records >> - do something with them, and still forget to set a flag that the >> action has already occurred. >> >> repeat, again and again with the results getting larger each time. Then >> the action which might have acted on 10 records to start, is now acting >> on thousands - appearing - to slow down. >> >> >> On Mon, 7 Nov 2016 16:28:51 +0100, stardata.info wrote: >>>>Hi Chip, >>>> >>>>At the end of the process that is slow after some time, i already do >>>>the your suggestions. >>>> >>>>Thanks >>>>/Ferdinando/ > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************