RE: Progressive slow

[stardata.info]

How can do the Info-report?

Thanks

Ferdinando


Il 08/11/2016 13:15, 4d_tech-requ...@lists.4d.com ha scritto:

Message: 1
Date: Tue, 8 Nov 2016 08:11:11 +
From: "Epperlein, Lutz (agendo)"<lutz.epperl...@agendo.de>
To: 4D iNug Technical<4d_tech@lists.4d.com>
Subject: RE: Progressive slow
Message-ID:<26ea80a7397b4535b5611885808e2...@vex1a.init.de>
Content-Type: text/plain; charset="utf-8"

I'm not sure, but did you send us a report produced by the Info-Report 
component?
I would recommend that you show us the report at startup and a second one when 
the application slows down. That means you have to set a rather short interval 
in the component.
Better yet, you contact the 4D support and show them these reports.

Regards
Lutz


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

RE: Progressive slow

[Epperlein, Lutz (agendo)]

I'm not sure, but did you send us a report produced by the Info-Report 
component?
I would recommend that you show us the report at startup and a second one when 
the application slows down. That means you have to set a rather short interval 
in the component.
Better yet, you contact the 4D support and show them these reports. 

Regards
Lutz
**
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
**

RE: Progressive slow

[STARDATA]

Chip,

Can you suggest the cache configuration in case of the pc or server have 4
Mb of ram and in case of 8Gb of ram?

Thanks
Ferdinando



--
View this message in context: 
http://4d.1045681.n5.nabble.com/Progressive-slow-tp5748225p5748465.html
Sent from the 4D Tech mailing list archive at Nabble.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
**

RE: Progressive slow

[Chip Scheide]

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

RE: Progressive slow

[stardata.info]

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

RE: Progressive slow

[stardata.info]

Hi Chip,

At the end of the process that is slow after some time, i already do the 
your suggestions.


Thanks
/Ferdinando/

Il 07/11/2016 16:02, 4d_tech-requ...@lists.4d.com ha scritto:

Message: 12
Date: Mon, 7 Nov 2016 10:02:35 -0500
From: Chip Scheide<4d_o...@pghrepository.org>
To: 4D iNug Technical<4d_tech@lists.4d.com>
Subject: RE: Progressive slow
Message-ID:<20161107100235041589.9243f...@pghrepository.org>
Content-Type: text/plain; charset=us-ascii

Hi Ferdindao,

I do not know what your process does. - but -
It does sound like there is an issue with memory.
Others have responded with ideas about changing cache settings, I would
follow there suggestions, too.

As I suggested, below, it is possible to create a memory leak - a
situation where 4D (your application) requests memory form 4D/system,
does stuff, finishes but does NOT return all of the requested memory to
4D/System. This is called a memory leak.

On a Mac, Safari and Firefox (windows too?) both have issues like this.
ex: open one of these programs memory usage is say 100 megs
You open 10, or 30, or 50 tabs
close all the tabs
memory usage might be 250 megs

repeat this enough times and your system slows down, or the application
crashes.

for 4D, as I said below, you need to make sure at the end of each
process (as it quits) the following items are cleared/emptied/removed
from memory; this may not be exhaustive, and if not others i'm sure
will chime in:)
(it is often best to clear these items as you finish using them, rather
then waiting until the end)
- sets
- selections
- arrays (locals are supposed to be cleared for you)
- Lists
- hierarchal lists (be sure to clear lowest level to highest)
- named selections
- and turn off Event, and Err call methods

if you have done the cache changes others suggest, and insure that all
of the above items are cleared, I would expect your slow downs to go
away.


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

RE: Progressive slow

[Chip Scheide]

Hi Ferdindao,

I do not know what your process does. - but -
It does sound like there is an issue with memory.
Others have responded with ideas about changing cache settings, I would 
follow there suggestions, too.

As I suggested, below, it is possible to create a memory leak - a 
situation where 4D (your application) requests memory form 4D/system, 
does stuff, finishes but does NOT return all of the requested memory to 
4D/System. This is called a memory leak.

On a Mac, Safari and Firefox (windows too?) both have issues like this.
ex: open one of these programs memory usage is say 100 megs
You open 10, or 30, or 50 tabs
close all the tabs
memory usage might be 250 megs

repeat this enough times and your system slows down, or the application 
crashes.

for 4D, as I said below, you need to make sure at the end of each 
process (as it quits) the following items are cleared/emptied/removed 
from memory; this may not be exhaustive, and if not others i'm sure 
will chime in  :)
(it is often best to clear these items as you finish using them, rather 
then waiting until the end)
- sets
- selections
- arrays (locals are supposed to be cleared for you)
- Lists
- hierarchal lists (be sure to clear lowest level to highest)
- named selections
- and turn off Event, and Err call methods

if you have done the cache changes others suggest, and insure that all 
of the above items are cleared, I would expect your slow downs to go 
away.



On Fri, 4 Nov 2016 23:51:23 +0100, stardata.info wrote:
> Chip,
> 
> The issue regard one process, but you must consider that i close and 
> open the process every time.
> 
> The same process after restarted the application work fine, but if i 
> open the process after many time, that the application work, the same 
> process is more slow.
> 
> Thanks
> /Ferdinando/
> 
> Il 04/11/2016 20:00, 4d_tech-requ...@lists.4d.com ha scritto:
>> Message: 2
>> Date: Fri, 4 Nov 2016 10:37:41 -0400
>> From: Chip Scheide<4d_o...@pghrepository.org>
>> To: 4D iNug Technical<4d_tech@lists.4d.com>
>> Subject: RE: Progressive slow
>> Message-ID:<20161104103741651171.cf01d...@pghrepository.org>
>> Content-Type: text/plain; charset=us-ascii
>> 
>> Dennis -
>> I agree with you on the memory issue.
>> 
>> However, the initial question was/is:
>> Why are searches quick(er?) after a restart and slow down after some
>> period of server up time.
>> This is not/should not be a client side issue - it is most likely a
>> cache issue...
>> 
>> However there is one other thing that no one has pointed out -
>> it could be that OP's 4D code has a memory leak - i.e. the code is
>> using memory for some action(s) and NOT releasing that memory back to
>> 4D/system.  This could also causes a restricted memory issue which
>> could force 4D to start using the disk (virtual memory/paging) during a
>> query.
>> 
>> To fix this problem (memory leak) will require some code analysis, and
>> likely some time.
>> To insure that memory is returned (and yes I know 4D does a much better
>> job at this now).
>> clear the following items at the end of a process, if not when the code
>> is finished using it.
>> (local arrays are supposed to be cleared automagically).
>> - arrays (set to size zero or clear variable)
>> - sets (clear set)
>> - named selections (clear named selection)
>> - Lists (hierarchal especially) and Transient lists (created by Array
>> to list) - Clear List, be sure to clear all levels of an hierarchal
>> list)
>> - selections
>> - turn off On Err call, On event call
>> 
>> On Tue, 1 Nov 2016 21:06:29 +, Dennis, Neil wrote:
>>>>With a 4GB machine you shouldn't use more than 2GB cache memory for
>>>>4D server.
>>>>
>>>>You can consider a bigger/faster computer to help processing speed...
>>>>often this is the easiest to increase performance.
>>>>
>>>>If you watch the server processes when there is a slowdown or when it
>>>>starts to get slower, is the CPU, network, or disk higher than normal?
>>>>
>>>>A lot of 4D server performance can be controlled in the way that 4D
>>>>code is written. Try to figure out what the client is doing with the
>>>>server is slow. The watch pane can tell you a lot about the code that
>>>>is executing when you are seeing slowness.
>>>>
>>>>There are a lot of things that can cause slow performance... Once you
>>>>figure out what code is causing the slowness see if you can optimize
>>>>it for server.
>>>>
>>>>Neil
> 
> **

RE: Progressive slow

[Timothy Penner]

See here:
http://kb.4d.com/assetid=76285

-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Timothy Penner
Sent: Wednesday, November 02, 2016 12:18 PM
To: 4D iNug Technical
Subject: RE: Progressive slow

> Since I think the question was about a v13 app you can only flush data in 
> minute increments so try 1 minute

Sorry that is wrong: the ability to set the flush interval in seconds began 
with v12.

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

RE: Progressive slow

[Timothy Penner]

> Since I think the question was about a v13 app you can only flush data in 
> minute increments so try 1 minute

Sorry that is wrong: the ability to set the flush interval in seconds began 
with v12.

-Tim

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

Re: Progressive slow

[Chuck Miller]

Given that he only has 4 Gig on machine I think 2048 is too big. He also should 
not be using adaptive cache. Try with 1024 and see it hat works. Since I think 
the question was about a v13 app you can only flush data in minute increments 
so try 1 minute

Regards

Chuck
 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase connectivity
  http://www.informed-solutions.com  



> On Nov 2, 2016, at 2:46 PM, stardata.info  wrote:
> 
> Hi Neil,
> 
> The unique changes that i can do is this:  Maximum Size: 2048 MB
> 
> I can change this settings ( Check Calculation of adaptive cache ) even when 
> the application is compiled?
> 
> 
> In the next days i try and see.

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

RE: Progressive slow

[Dennis, Neil]

> I can change this settings ( Check Calculation of adaptive cache ) even when 
> the application is compiled?

I'm not sure if you can or cannot compiled. I think that you can. If not don't 
worry about it, just set the max to 2048.

Neil









--

Privacy Disclaimer: This message contains confidential information and is 
intended only for the named addressee. If you are not the named addressee you 
should not disseminate, distribute or copy this email. Please delete this email 
from your system and notify the sender immediately by replying to this email.  
If you are not the intended recipient you are notified that disclosing, 
copying, distributing or taking any action in reliance on the contents of this 
information is strictly prohibited.

The Alternative Investments division of UMB Fund Services provides a full range 
of services to hedge funds, funds of funds and private equity funds.  Any tax 
advice in this communication is not intended to be used, and cannot be used, by 
a client or any other person or entity for the purpose of (a) avoiding 
penalties that may be imposed on any taxpayer or (b) promoting, marketing, or 
recommending to another party any matter addressed herein.
**
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
**

Re: Progressive slow

[Neil Dennis]

> How i must set this value?


I saw in another message what your memory settings are. It looks like the 
maximum size is set to 100MB so let’s try this:

In database settings, click on Database, then click on Memory.

If you run the application on multiple computers of different sizes then:
Check Calculation of adaptive cache
Memory to be reserved for other applications and for the system: 512 MB
Percentage of available memory used for cash: 50%
Minimum Size: 100 MB
Maximum Size: 2048 MB
Uncheck Keep the cache in physical memory for 4D Server and 4D Volume 
Desktop

Flush Data Buffers every: 20 seconds


If you only run the application on the one computer with 4GB ram
Uncheck Calculation of adaptive cache
Size 2048 MB

Flush Data Buffers every: 20 seconds

Restart the 4D server and see what that does for you.


Neil

--
Neil Dennis
4D Developer since 1990

GreaText - Designing Software for the Way You Work
716 East 1850 N
North Ogden, UT 84414

mailto:npden...@greatext.com
http://www.greatext.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
**

RE: Progressive slow

[Dennis, Neil]

> After the restart of the 4D Application all work normally, after some time 
> expecially the query operations are more slow of when the 4D application are 
> restarted.

In this case I might suggest a smaller cache, it could be that your machine is 
running out of free memory and paging you cache memory. As Chuck suggested try 
1024K and see what happens.



Neil


--



Privacy Disclaimer: This message contains confidential information and is 
intended only for the named addressee. If you are not the named addressee you 
should not disseminate, distribute or copy this email. Please delete this email 
from your system and notify the sender immediately by replying to this email.  
If you are not the intended recipient you are notified that disclosing, 
copying, distributing or taking any action in reliance on the contents of this 
information is strictly prohibited.

The Alternative Investments division of UMB Fund Services provides a full range 
of services to hedge funds, funds of funds and private equity funds.  Any tax 
advice in this communication is not intended to be used, and cannot be used, by 
a client or any other person or entity for the purpose of (a) avoiding 
penalties that may be imposed on any taxpayer or (b) promoting, marketing, or 
recommending to another party any matter addressed herein.
**
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
**

RE: Progressive slow

[stardata.info]

After the restart of the 4D Application all work normally, after some 
time expecially the query operations are more slow of when the 4D 
application are restarted.


Thanks
Ferdinando

Il 01/11/2016 22:17, 4d_tech-requ...@lists.4d.com ha scritto:

Message: 4
Date: Tue, 1 Nov 2016 21:06:29 +
From: "Dennis, Neil"<neil.den...@umb.com>
To:"4d_tech@lists.4d.com"  <4d_tech@lists.4d.com>
Subject: RE: Progressive slow
Message-ID:
<838740227206e84f82973ff5d9ea59b74a75f...@wsys6041a.umb.corp.umb.com>
Content-Type: text/plain; charset="utf-8"

With a 4GB machine you shouldn't use more than 2GB cache memory for 4D server.

You can consider a bigger/faster computer to help processing speed... often 
this is the easiest to increase performance.

If you watch the server processes when there is a slowdown or when it starts to 
get slower, is the CPU, network, or disk higher than normal?

A lot of 4D server performance can be controlled in the way that 4D code is 
written. Try to figure out what the client is doing with the server is slow. 
The watch pane can tell you a lot about the code that is executing when you are 
seeing slowness.

There are a lot of things that can cause slow performance... Once you figure 
out what code is causing the slowness see if you can optimize it for server.

Neil




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

Re: Progressive slow

[Charles Miller]

On Tue, Nov 1, 2016 at 4:49 PM, stardata.info 
wrote:

> 4 GB
>

Great your cache should not be set bigger than 1024. once again how big is
data file(file size), number of records?
Cache should *NOT* be set to adaptive

Is there any other stuff running on your server machine. How are setting in
4D re cpu priotities. How long for data flush. This is something
overlooked. If you are flushing every 20 minutes it will take 20 times
longer than every minute on average, but appear to be much slower, as there
is 20 times more to be flushed. In pre v15 I always set to 1 minute. In 15
and higher I set for between 15 and 30 seconds.


Regards


Chuck


-- 
-
 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 Sever connectivity
  http://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)
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
**

RE: Progressive slow

[Dennis, Neil]

With a 4GB machine you shouldn't use more than 2GB cache memory for 4D server.

You can consider a bigger/faster computer to help processing speed... often 
this is the easiest to increase performance.

If you watch the server processes when there is a slowdown or when it starts to 
get slower, is the CPU, network, or disk higher than normal?

A lot of 4D server performance can be controlled in the way that 4D code is 
written. Try to figure out what the client is doing with the server is slow. 
The watch pane can tell you a lot about the code that is executing when you are 
seeing slowness.

There are a lot of things that can cause slow performance... Once you figure 
out what code is causing the slowness see if you can optimize it for server.

Neil





--

Privacy Disclaimer: This message contains confidential information and is 
intended only for the named addressee. If you are not the named addressee you 
should not disseminate, distribute or copy this email. Please delete this email 
from your system and notify the sender immediately by replying to this email.  
If you are not the intended recipient you are notified that disclosing, 
copying, distributing or taking any action in reliance on the contents of this 
information is strictly prohibited.

The Alternative Investments division of UMB Fund Services provides a full range 
of services to hedge funds, funds of funds and private equity funds.  Any tax 
advice in this communication is not intended to be used, and cannot be used, by 
a client or any other person or entity for the purpose of (a) avoiding 
penalties that may be imposed on any taxpayer or (b) promoting, marketing, or 
recommending to another party any matter addressed herein.
**
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
**

Re: Progressive slow

[stardata.info]

4 GB


Il 01/11/2016 20:00, 4d_tech-requ...@lists.4d.com ha scritto:

Message: 9
Date: Tue, 1 Nov 2016 12:45:38 -0400
From: Charles Miller<miller.c...@gmail.com>
To: 4D iNug Technical<4d_tech@lists.4d.com>
Subject: Re: Progressive slow
Message-ID:

Re: Progressive slow

[Charles Miller]

On Tue, Nov 1, 2016 at 11:22 AM, stardata.info 
wrote:

>
> I understand your suggestion, but in task manager the ram used is only
> 1,06 Gb.
>
> Thanks
> /Ferdinando/

ok but how much is on machine
regards

chuck



-- 
-
 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 Sever connectivity
  http://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)
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
**

RE: Progressive slow

[stardata.info]

Hi Lutz,

I understand your suggestion, but in task manager the ram used is only 
1,06 Gb.


Thanks
/Ferdinando/

Il 01/11/2016 15:43, 4d_tech-requ...@lists.4d.com ha scritto:

Message: 9
Date: Tue, 1 Nov 2016 08:07:20 +
From: "Epperlein, Lutz (agendo)"<lutz.epperl...@agendo.de>
To: 4D iNug Technical<4d_tech@lists.4d.com>
Subject: RE: Progressive slow
Message-ID:<3854989ef57545d1addb31656f14c...@vex1a.init.de>
Content-Type: text/plain; charset="utf-8"

  

>Db is  4.716.737 Kb
>
>Ram 4GB

This explains all. What see is typical behavior of an app running on a machine 
with low memory. In the beginning all is well, but after a time the physical 
RAM is full and swapping begins.


>" How much assigned to 4D?"  Where i can see this?

Don't worry about that. Give your machine more RAM, at least 8GB.

Regards
Lutz



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

RE: Progressive slow

[Epperlein, Lutz (agendo)]

 
> Db is  4.716.737 Kb
> 
> Ram 4GB

This explains all. What see is typical behavior of an app running on a machine 
with low memory. In the beginning all is well, but after a time the physical 
RAM is full and swapping begins.

> " How much assigned to 4D?"  Where i can see this?

Don't worry about that. Give your machine more RAM, at least 8GB.

Regards
Lutz

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

Re: Progressive slow

[Wayne Stewart]

Hi,

Do you have access to the info report component? I think it may only
be available to partners but if you can get it and can be very useful
for examining these sorts of issues.

Regards,

Wayne


Wayne Stewart
about.me/waynestewart




On 1 November 2016 at 07:19, Benedict, Tom  wrote:
> "Dennis, Neil" > writes:
>
>>> Don't think you can do this in 13.x I think max cache size is 2 gig
>
>>Doesn't that depend on the OS? Doesn't 13.x have a 64 bit sever for windows? 
>>Perhaps not, it has been a while since I used 4D v13.
>
> 13.x Server has a 64bit version on Windows.
>
> Tom
>
> This e-mail, including attachments, may include confidential and/or
> proprietary information, and may be used only by the person or entity
> to which it is addressed. If the reader of this e-mail is not the intended
> recipient or his or her authorized agent, the reader is hereby notified
> that any dissemination, distribution or copying of this e-mail is
> prohibited. If you have received this e-mail in error, please notify the
> sender by replying to this message and delete this e-mail immediately.
> **
> 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
**

Re: Progressive slow

[stardata.info]

Hi Chuck,

Db is  4.716.737 Kb

Ram 4GB

" How much assigned to 4D?"  Where i can see this?

On server run: Team Viewer and normal system software
Operating system Windows 2088 R2 Standard.

Thanks
Ferdinando


Il 31/10/2016 20:00, 4d_tech-requ...@lists.4d.com ha scritto:

Message: 2
Date: Mon, 31 Oct 2016 13:52:07 -0400
From: Chuck Miller<cjmil...@informed-solutions.com>
To: 4DTechList Tech<4d_tech@lists.4d.com>
Subject: Re: Progressive slow
Message-ID:
<ed9923f8-d82a-49be-85e7-a761f30c2...@informed-solutions.com>
Content-Type: text/plain; charset=us-ascii

How big is data file? How much memory on the machine? How much assigned to 4D? 
Is there anything else on the server? You should be running 13.6 not 13.3.
Is there something else happening within 4D that might be causing this?

Regards

Chuck

  Chuck Miller Voice: (617) 739-0306
  Informed Solutions, Inc. Fax: (617) 232-1064
mailto:cjmillerinformed-solutions.com
  Brookline, MA 02446 USA Registered 4D Developer
Providers of 4D and Sybase connectivity
   http://www.informed-solutions.com   





>On Oct 28, 2016, at 6:20 PM, stardata.info<stard...@stardata.info>  wrote:
>
>Hi All,
>
>In one 4D V13.3 application in client server on windows, from some time, i 
notice that some query after some hours of use become slow, if i close and reopen 
the application are new fast.
>
>The database is great
>
>Someone have a suggestion for solve?
>
>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
**

Re: Progressive slow

[Randy Jaynes]

Whether or not it actually uses it, the v13 server does allow it to be set to 
4000 and shows it in bold as a customized value.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • (845) 359-0298 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 


 

> On Oct 31, 2016, at 1:53 PM, Chuck Miller  
> wrote:
> 
> Don’t think you can do this in 13.x I think max cache size is 2 gig

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

RE: Progressive slow

[Dennis, Neil]

> Don’t think you can do this in 13.x I think max cache size is 2 gig

Doesn't that depend on the OS? Doesn't 13.x have a 64 bit sever for windows? 
Perhaps not, it has been a while since I used 4D v13.


Neil












--

Privacy Disclaimer: This message contains confidential information and is 
intended only for the named addressee. If you are not the named addressee you 
should not disseminate, distribute or copy this email. Please delete this email 
from your system and notify the sender immediately by replying to this email.  
If you are not the intended recipient you are notified that disclosing, 
copying, distributing or taking any action in reliance on the contents of this 
information is strictly prohibited.

The Alternative Investments division of UMB Fund Services provides a full range 
of services to hedge funds, funds of funds and private equity funds.  Any tax 
advice in this communication is not intended to be used, and cannot be used, by 
a client or any other person or entity for the purpose of (a) avoiding 
penalties that may be imposed on any taxpayer or (b) promoting, marketing, or 
recommending to another party any matter addressed herein.
**
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
**

Re: Progressive slow

[Chuck Miller]

Don’t think you can do this in 13.x I think max cache size is 2 gig

Regards

Chuck

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase connectivity
  http://www.informed-solutions.com  



> On Oct 28, 2016, at 10:52 PM, Randy Jaynes  wrote:
> 
> Sounds like the database cache settings on the server are off. I had a 
> similar problem some months back which went away when I returned to factory 
> settings and bumped the maximum up to 4000MB.
> 
> This was in Database Settings -> Memory Tab.
> 
> Randy
> 
> --
> Randy Jaynes
> Senior Programmer and Customer Support
> 
> http://printpoint.com • (845) 359-0298 • PrintPoint, Inc • 57 Ludlow Lane • 
> Palisades, NY 10964 
> 
> 
> 
> 
>> On Oct 28, 2016, at 6:20 PM, stardata.info  wrote:
>> 
>> Hi All,
>> 
>> In one 4D V13.3 application in client server on windows, from some time, i 
>> notice that some query after some hours of use become slow, if i close and 
>> reopen the application are new fast.
>> 
>> The database is great
>> 
>> Someone have a suggestion for solve?
> 
> 
> **
> 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
**

Re: Progressive slow

[Chuck Miller]

How big is data file? How much memory on the machine? How much assigned to 4D? 
Is there anything else on the server? You should be running 13.6 not 13.3.
Is there something else happening within 4D that might be causing this?

Regards

Chuck

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase connectivity
  http://www.informed-solutions.com  



> On Oct 28, 2016, at 6:20 PM, stardata.info  wrote:
> 
> Hi All,
> 
> In one 4D V13.3 application in client server on windows, from some time, i 
> notice that some query after some hours of use become slow, if i close and 
> reopen the application are new fast.
> 
> The database is great
> 
> Someone have a suggestion for solve?
> 
> 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
**

Re: Progressive slow

[Randy Jaynes]

Sounds like the database cache settings on the server are off. I had a similar 
problem some months back which went away when I returned to factory settings 
and bumped the maximum up to 4000MB.

This was in Database Settings -> Memory Tab.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • (845) 359-0298 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 


 

> On Oct 28, 2016, at 6:20 PM, stardata.info  wrote:
> 
> Hi All,
> 
> In one 4D V13.3 application in client server on windows, from some time, i 
> notice that some query after some hours of use become slow, if i close and 
> reopen the application are new fast.
> 
> The database is great
> 
> Someone have a suggestion for solve?


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