gmane.comp.lang.inug-4d.tech

RE: Cache purging

Joshua Fletcher — 2013-06-19T23:47:48

There's also a Tech Note that covers this:

http://kb.4d.com/assetid=76368

And a Tech Tip:

http://kb.4d.com/assetid=76648

But to answer your questions directly:




-----Original Message-----

% of cache left does not trigger a purge unless you mean 0%.


4D will only purge if there is not enough free space to allocate the needed objects*.  It's not about percentage used, it's about space remaining.

* or if you call FLUSH BUFFERS(*), which you should only do for troubleshooting.

Kind regards,

Josh

--
Josh Fletcher
Technical Account Manager
4D, Inc.


**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe-d2/MUvgItPNWk

Re: Applescript

miyako — 2013-06-19T23:04:51

Hello,

I had some time to review the v11 component,
turns out the AppleScript to read the stdIn passed from LAUNCH EXTERNAL PROCESS
no longer works on OS X 10.8.

set stdin to do shell script "cat /dev/stdin"

c.f.

http://stackoverflow.com/questions/13973347/how-applescript-can-get-stdin-inside-the-code

I've change the code to use a temporary file,
also switched from Internet Commands to HTTP Get. (the component is now v13)

http://sources.4d.com/trac/4d_keisuke/wiki/Components/SOAP%20Script%20Generator

https://github.com/miyako/4d-utility-soap-script-generator

tested on 10.8.4 4D v13.3

miyako

On 2013/06/17, at 17:25, Jeremy Roussak <jbr-ee4meeAH724< at >public.gmane.org> wrote:







**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.ht

Re: [OFF] Stupid User Reports

David Adams — 2013-06-19T18:22:37

Random thoughts:

* Sadly, there isn't a "right" date format as it very much depends on
location. I end up using three formats on a daily basis:

Re: Cache purging

Bill Weale — 2013-06-19T14:12:12

Thanks!

Here's the Google English version:


After reviewing the tables of process variables and inter-process in the previous post, we continue our exploration of memory by studying the cache.
The memory cache is dedicated to data. We find in this memory area records, indexes, and all that is necessary for their management: current selections, allocation tables, tables of addresses ...
 
When a database is opened by 4D engine, the parameters of the cache are read and the engine attempts to allocate the requested memory. But before we go any further, back to the starting point and exact parameterization of the base.
 
Allocation of cache

Cache memory is allocated from the start of the base, and this once and for all. It can no longer grow or shrink in the future. It is therefore essential to the well dimension. Unfortunately there is no magic formula to fail to give the right size to cache, it would be too easy! We will discuss later in this article how the cache and give you some food for thought and anal

Re: [OFF] Stupid User Reports

Sujit Shah — 2013-06-19T03:30:38

I feel dates should work no matter what the system date is. Like it or not
user expectations revolve around browser apps. Some of The under 30s have
never seen a desktop application!



On Wednesday, 19 June 2013, Arnaud de Montard wrote:

Re: EXPAND BLOB Crashing v13.3 Occasionally

Cannon Smith — 2013-06-19T15:14:45

Hi Miyako and David,

Thanks for the ideas. For compression I'm using the Compact compression mode. I have a wrapper for expanding that checks the compression state and only expands if it is compressed.

The weird thing is that the customer relaunches 4D and it expands the same blob with no problem right after the crash. It isn't consistent.

--
Cannon Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236
<cannon-w3oKhh0s6AnxjwyQg7JAM8yiEOaA11gU< at >public.gmane.org>
<www.synergyfarmsolutions.com>


On Jun 19, 2013, at 9:08 AM, David Lieb <david_lieb-cIpcPs7DjqbWs/AcZQh2Cw< at >public.gmane.org> wrote:



**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-

Re: EXPAND BLOB Crashing v13.3 Occasionally

David Lieb — 2013-06-19T15:08:37

Is it possible the problem BLOBs are not compressed at all? According to the
COMPRESS BLOB documentation, "This command only compresses BLOB whose size
is over 255 bytes."

David


Cannon Smith wrote







--
View this message in context: http://4d.1045681.n5.nabble.com/EXPAND-BLOB-Crashing-v13-3-Occasionally-tp5723112p5723129.html
Sent from the 4D Tech mailing list archive at Nabble.com.

**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: EXPAND BLOB Crashing v13.3 Occasionally

miyako — 2013-06-19T14:39:06

Hello,

for the record, 
BASE64 DECODE is the command to decode base64, not EXPAND BLOB.

starting from v13, 
you can choose which mode to run EXPAND BLOB, for example, gzip.

in any case, 
you can call BLOB PROPERTIES to guess which mode was applied.

moreover,
WEB SEND TEXT/BLOB/FILE has built in gzip support in v13,
so it would be redundant to compress a BLOB before passing it to these commands.

miyako

On 2013/06/19, at 7:37, Peter Bozek <peter.bozek-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:







**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**************************************************

Re: Cache purging

miyako — 2013-06-19T14:31:07

Hello,

I should have been more clear about the use of the verb "purge".

in the OP I was referring to the BSD purge command,

http://developer.apple.com/library/mac/#documentation/Darwin/Reference/ManPages/man8/purge.8.html

or 

http://kb.4d.com/assetid=75978

the article by Olivier explains the 4D cache purge.

http://kb.4d.com/assetid=76443

miyako

On 2013/06/19, at 23:06, Arnaud de Montard <arnaud-riHswgkMmCA< at >public.gmane.org> wrote:







**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: Cache purging

Arnaud de Montard — 2013-06-19T14:06:45

Le 19 juin 2013 à 15:32, Bill Weale a écrit :


Olivier Deschanels wrote this article about cache:
<http://www.4d.com/fr/blog/123soleil.html>
no translation  :-(

Re: EXPAND BLOB Crashing v13.3 Occasionally

Cannon Smith — 2013-06-19T13:34:37

Hi Keith,

I did notice that. Also, that it was a MacIntel fix and my customers are on Windows. I'm definitely looking into this one.

Thanks for the heads up.

--
Cannon Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236
<cannon-w3oKhh0s6AnxjwyQg7JAM8yiEOaA11gU< at >public.gmane.org>
<www.synergyfarmsolutions.com>


On Jun 19, 2013, at 7:29 AM, Keith White <KWhite-L9gXfNRv2/vRZ1oM81ef8Q< at >public.gmane.org> wrote:



**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: EXPAND BLOB Crashing v13.3 Occasionally

Cannon Smith — 2013-06-19T13:33:27

Hi Bryan,

The blobs are coming from records so I'm pretty sure they aren't being modified. It is different blobs that cause the issue each time. I'm trying to create a way to automatically capture a bad blob right now, so hopefully that will tell me more.

Thanks for the idea.

--
Cannon Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236
<cannon-w3oKhh0s6AnxjwyQg7JAM8yiEOaA11gU< at >public.gmane.org>
<www.synergyfarmsolutions.com>


On Jun 18, 2013, at 8:20 PM, Bryan Green <bryan-Tl/od7OxOgZBDgjK7y7TUQ< at >public.gmane.org> wrote:



**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
*****************

Cache purging

Bill Weale — 2013-06-19T13:32:54

What triggers 4D to clear its cache?

Anything other than % of cache left?

Any idea if there is a % used below which it won't try?

Thanks,

Bill


William W. Weale, III

Business Owners Support, LLC.

Operations Analysis
MIS Advising
Decision Support Systems


**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: GET DATA SOURCE LIST mystery

Spencer Hinsdale — 2013-06-19T13:32:16

Go to Windows to SysWOW64 folder and run odbcad32.exe found there.

-spencer


On Jun 19, 2013, at 6:14 AM, Ancel Sherrard <asherrard-Wuw85uim5zDR7s880joybQ< at >public.gmane.org> wrote:


**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: EXPAND BLOB Crashing v13.3 Occasionally

Keith White — 2013-06-19T13:29:13

Hi

Looks like a possible new issue introduced in a change to EXPAND BLOB in 13.3 ? :-


ACI0078799 - 4D quits unexpectedly on "EXPAND BLOB"

4D quits unexpectedly on calling "EXPAND BLOB" if a blob is damaged.
This is now fixed with 4D 12.6 and 4D 13.3


Best regards

Keith White
Synergist Express Ltd, UK



**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

GET DATA SOURCE LIST mystery

Ancel Sherrard — 2013-06-19T13:14:52

Windows 7 server, 4D v12 client/server

The following code on the 4D server returns a list of system DSN's in
$atName.

ARRAY TEXT($atName;0)
ARRAY TEXT($atDriver;0)
GET DATA SOURCE LIST(System Data Source;$atName;$atDriver)

The only problem is that it returns DSN's that were created on the server a
year ago, but now changes made using the ODBC data source administrator do
not appear in the array.

The IT person who originally created the DSN's for me is no longer there, so
I don't know how he got into the server to create the DSN's (i.e., what
privileges he had). But now it is my task to update them. Is there some sort
of access privileges issue at work here? Or even possibly some sort of cache
in 4D that is not being updated? 

Ancel Sherrard
Sherrard & Howard Consulting


**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

4D Internet Users Group (4

Re: Event publishing from 4D

Ortwin Zillgen — 2013-06-19T06:49:41

<http://dddd.mettre.de/icsoutlook.shtml>


Regards
O r t w i n  Z i l l g e n
---------------------------------------------
<mailto:info-x85BCD9UzoazQB+pC5nmwQ< at >public.gmane.org>   <http://dddd.mettre.de?4713>
<feed://dddd.mettre.de/dddd.xml> <https://twitter.com/Ozett>
member of developer-network <http://www.die4dwerkstatt.de>


**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: EXPAND BLOB Crashing v13.3 Occasionally

Bryan Green — 2013-06-19T02:20:41

Are these blobs transmitted over a network connection outside of 4D? In
other words, are they being modified perhaps?

Re: [OFF] Stupid User Reports

Arnaud de Montard — 2013-06-18T22:45:29

Le 18 juin 2013 à 23:32, Dennis Little a écrit :


In France, we express date "dd/mm/aa" and time "hh:mm:ss". Since I work with computers I wonder why the former starts with the smaller time unit, while the latter ends with it… How I like the metric system!  ;-)

I use "yymmdd" in some tables where date is "one of the most important fields" (like calendars). Users begin to like it when they understand they can search within time with reduced entry:
  "13" -> 2013
  "1306" -> june 2013
  "13061" -> june 2013, june, day 10 to 19
And with timestamps fields, you can go on:
  "1306190045" -> send timestamp of this mail (in France, of course)

Re: EXPAND BLOB Crashing v13.3 Occasionally

Cannon Smith — 2013-06-18T22:44:45

Hi Peter,

Most of the blobs are less than 1 KB. The biggest is 38 KB (in compressed state).

Thanks for the idea, though.

--
Cannon Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236
<cannon-w3oKhh0s6AnxjwyQg7JAM8yiEOaA11gU< at >public.gmane.org>
<www.synergyfarmsolutions.com>


On Jun 18, 2013, at 4:37 PM, Peter Bozek <peter.bozek-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:



**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: [OFF] Stupid User Reports

Peter Bozek — 2013-06-18T22:16:28



well, there is a ISO standard for date display, and it is yyyy-mm-dd -
which has an additional advantage that even as string the dates are sorted
correctly.

YEs, I know it is not used much and may be confusing to users that are
awaiting other format, but I am not sure it is good excuse to not using it.

For example I use Chrome ability to translate any page to English, and it
does very good job - except of dates. As I often buy plane and train
tickets and rent hotels on german web pages, this is a problem, and use of
ISO date format would solve it. So I am watching who is using it - and it
seems it is starting to be used (though still not as much as I would like.)