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

4DDB CRON is running?

[David Adams]

Any background information on this V15 message at quit?

I didn't find anything in kb.4d.com or the V15 docs.

Thanks.
**
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: OSX Window Sheets versus what to do on windows

[Jeffrey Kain]

What's wrong with a normal movable modal dialog box?

> On Nov 7, 2016, at 6:09 PM, truegold  wrote:
> 
> Not so on windows!
> 
> Since I’d like my apps to look similar on both OSX and Windows I’m guessing I 
> will have to consider a different approach to window management.

**
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: OSX Window Sheets versus what to do on windows

[Timothy Penner]

> with a web-area based UI, 
> you could do all sorts of things... 

Possibly related...
http://kb.4d.com/assetid=77177

-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: OSX Window Sheets versus what to do on windows

[Keisuke Miyako]

just be careful to test in a web area at an early stage,
some features are native only, mac only, webkit only, or mac-webkit only.
(very few things are windows-only)

> 2016/11/08 8:51、truegold  のメール：
> Maybe I shouldn’t ask about sheets versus and instead ask how others are 
> handling dialogs in cross platform apps.



宮古 啓介
セールス・エンジニア

株式会社フォーディー・ジャパン
〒150-0043
東京都渋谷区道玄坂1-10-2 渋谷THビル6F
Tel: 03-6427-8441
Fax: 03-6427-8449

keisuke.miy...@4d.com
www.4D.com/JP

**
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: OSX Window Sheets versus what to do on windows

[truegold]

Hi Miyako,

Yes that’s very slick!

I use web areas in other databases. And I will investigate this further for 
future projects. It’s amazing what css is evolving into.

For this project however I think I want something simpler that just looks 
similar on Mac and windows.

Maybe I shouldn’t ask about sheets versus and instead ask how others are 
handling dialogs in cross platform apps.

Which window types work best cross platform and are consistent with UI specs.

Thank you for the idea,
John...

> with a web-area based UI, 
> you could do all sorts of things... 
> 
> http://tympanus.net/codrops/2013/06/25/nifty-modal-window-effects/


**
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: OSX Window Sheets versus what to do on windows

[Keisuke Miyako]

with a web-area based UI,
you could do all sorts of things...

http://tympanus.net/codrops/2013/06/25/nifty-modal-window-effects/

> 2016/11/08 8:09、truegold  のメール：
> Looks like it’s time that I go back to UI school.



宮古 啓介
セールス・エンジニア

株式会社フォーディー・ジャパン
〒150-0043
東京都渋谷区道玄坂1-10-2 渋谷THビル6F
Tel: 03-6427-8441
Fax: 03-6427-8449

keisuke.miy...@4d.com
www.4D.com/JP

**
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: Why won't Help Tip editor accept Carriage Return?

[Keisuke Miyako]

also useful to know about help tips:

1. they can be set by code (since v13):
http://doc.4d.com/4Dv16/4D/16/OBJECT-SET-HELP-TIP.301-3036170.en.html

2. the editor is not XLIFF compliant. the language, by contrast, supports XLIFF:

http://doc.4d.com/4Dv16/4D/16/OBJECT-Get-help-tip.301-3036177.en.html
http://doc.4d.com/4Dv16/4D/16/Help-Tip-editor.300-3049012.en.html

> 2016/11/08 6:22、Keith Goebel  のメール：
> Have a method that either populates the variables or clears them - depending 
> on whether you want text to display in the tips.



宮古 啓介
セールス・エンジニア

株式会社フォーディー・ジャパン
〒150-0043
東京都渋谷区道玄坂1-10-2 渋谷THビル6F
Tel: 03-6427-8441
Fax: 03-6427-8449

keisuke.miy...@4d.com
www.4D.com/JP

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

Missing Getters - Form Get Input, Form Get Output

[Chip Scheide]

Looks like these 2 commands are missing.

We have : 
Form Set Input
Form Set OUtput

BUT no getters to determine the current input/output form for a table
anyone interested? I can create a feature request...

Chip
**
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: How to override "Remember Me" on login?

[Kirk Brooks]

Thanks Tim

Yeah, that was my first thought too. The shiftkey workaround is all we
needed in this case. I just had to find it.

On Mon, Nov 7, 2016 at 9:59 AM, Timothy Penner  wrote:

> > You hold down the Shiftkey duringing login.
>
> Another option could be removing the 4dlink file:
> http://kb.4d.com/assetid=76151
> ^this routine could be implemented in code if you wanted to prevent the
> user from saving the password.
>
> -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
> **
>



-- 
Kirk Brooks
San Francisco, CA
===
**
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: How to override "Remember Me" on login?

[Timothy Penner]

> You hold down the Shiftkey duringing login.

Another option could be removing the 4dlink file:
http://kb.4d.com/assetid=76151
^this routine could be implemented in code if you wanted to prevent the user 
from saving the password.

-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: intermittent 10042 SMTP 550 mail box unavailable

[David Samson]

We had a similar problem when the mail server was moved to the cloud. The
solution was to increase the timeout (I think one minute was enough.)

HTH
David Samson
Manchester
UK


>
>
> A customer sending emails from a variety of computers within their LAN
> intermittently gets 10042 SMTP 550 mail box unavailable.
>
> We changed the sending configuration a few months ago and things worked
> much better for a while, but this error (10042 SMTP 550 mail box
> unavailable) is becoming more common.
>
> The settings are:
>
> Time-out: 30
> SMTP Host: smtpout.secureserver.net
> SMTP Port: 465 or 80
> POP3 Port: 995 or 110
> POP3 Host: pop.secureserver.net
> Return Email: nothi...@see.here
> User Name: notrecogniza...@user.name
> Password: *1%#)@NOTACTUALPASSWORDHERE
> SMTP Auth: True
> SSL SMTP: True
>
> I need some suggestions please!
>
> Thanks!
>
> David Ringsmuth
>
>
>
>
**
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: my Connect plugin help?

[Randy Jaynes]

Jim,

I had tried building my own statement, as you see, as well as creating a 
statement using the plugin command
mySQL Set DateTime in SQL

That is how I originally started and was failing because I figured myConnect 
would be taking care of these formatting issues.

When that failed, I switched to trying to build my own statement so that could 
actually see what the SQL was that was being executed.

But that failed too.

For now, I’m just letting the web programmer time the links out himself. If 
someone tries to use an expired link, he lets them know and clears out the old 
one.

In essence, I gave up an went with his more expedient solution.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

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


 

> On Nov 6, 2016, at 7:12 PM, Jim Labos - infobase  wrote:
> 
> in your statement:
> 
> $statement:="SELECT contactLogin FROM Contacts WHERE
> reset_password_token_created_at<='2016-11-02 17:09:46’;”
> 
> 
> The end of the date time is .46’ the last single quote is not same as
> first quote ( ' vs ’ ). I've had problems in the past where the quote
> character breaks the statement depending on what it is. Worth a try at
> least.
> 
> Have you got sql errors on? myConnect is not as forgiving as Sequel Pro is.
> 
> Cheers
> 
> Jim Labos - infobase
> 
> 
> 
> -
> Jim Labos - infobase
> --
> View this message in context: 
> http://4d.1045681.n5.nabble.com/my-Connect-plugin-help-tp5748349p5748436.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
> **

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