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]
**********************************************************************