Re: Longitude Index: B-Tree or Cluster

[Arnaud de Montard via 4D_Tech]

> Le 10 avr. 2020 à 02:03, John J Foster via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> Hi All,
> 
> I have a GEO database of almost 5 million cities. They include various data 
> and latitude and longitude.
> 
> I need to use the Longitude file in searches. To speed it up I need to index. 
> Many of the values are similar like 141.235 or 141 3.23 and so on. So for 
> those who might know would a Cluster index be better suited or a B-Tree?

I'd try distinct values first, a cluster is supposed to be better when there's 
enough repeated values. And most probably I'd try… I didn't understand from 
"141.235 or 141 3.23": what is the field type? 
You may also consider using another field with "simplified value" from 
longitude, depending on what's expected from that search. Or, if the search is 
always combined with other fields than longitude, make some tests and analyse 
query plan/query path to see if that index is required. 

-- 
Arnaud de Montard 




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

Re: 4D Server v18.1LTS - Startup Takes 10-15 Minutes

[Keisuke Miyako via 4D_Tech]

first off, I don't have any answers to your questions.

but if I may throw some ideas:

> I have an application I'm trying to convert from 4D v17R6 to v18.1LTS. It is 
> hosted on Windows Server 2016. It was a well-behaved application when running 
> v17R6 with no notable issues. However, now that it has been upgraded and 
> running on v18.1 LTS, it takes 10-15 minutes for the application to start-up 
> in 4D Server. Specifically, from the moment that the database is selected 
> from the Open... menu item until the Server Administration Window appears is 
> between 10 and 15 minutes.

is it possible that the application, for whatever reason, needs to copy all 
your database files to a virtual store?

---

also, windows server by default has a conservative power plan, which prevents 
4D Server from drawing on its full potential.

https://support.microsoft.com/en-us/help/2207548/slow-performance-on-windows-server-when-using-the-balanced-power-plan
https://docs.microsoft.com/en-us/windows-server/administration/performance-tuning/hardware/power/power-performance-tuning

of course, that does not explain why 17 R6 is doing just fine.

---

> The same application opens pretty much instantly when running in single-user 
> mode on my development machine (Windows 10 Pro). So the only difference is 
> host application (4D Server) and OS.

what about the hardware?
more specifically, do you know if the storage is HD or SSD?

> I would rule out the OS being an issue since the same application ran fine on 
> the same host machine and opened with no delay just prior to the upgrade from 
> v17R6 to v18.1LTS.

have you tried to launch 4D Server on your dev. machine, Windows 10 Pro,
to see if the correlation is really linked to the application type?

and just to rule out that the issue is not application specific,
you might want to compare the time with a fresh 4DB.
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4D Server v18.1LTS - Startup Takes 10-15 Minutes

[4dinug via 4D_Tech]

I have an application I'm trying to convert from 4D v17R6 to v18.1LTS. 
It is hosted on Windows Server 2016. It was a well-behaved application 
when running v17R6 with no notable issues. However, now that it has been 
upgraded and running on v18.1 LTS, it takes 10-15 minutes for the 
application to start-up in 4D Server. Specifically, from the moment that 
the database is selected from the Open... menu item until the Server 
Administration Window appears is between 10 and 15 minutes.


Insofar as I can tell from timestamps in internal logging in my 
application, this is all before a single line of code of my app runs. 4D 
Server gives no indication that anything is happening during this time 
interval (i.e., no progress bars, etc.). The same application opens 
pretty much instantly when running in single-user mode on my development 
machine (Windows 10 Pro). So the only difference is host application (4D 
Server) and OS. I would rule out the OS being an issue since the same 
application ran fine on the same host machine and opened with no delay 
just prior to the upgrade from v17R6 to v18.1LTS.


Might anyone have any insight as to why 4D Server is performing so 
badly? This makes it pretty much unusable. Unless I can find a solution, 
I will have to write version 18.1 LTS off as not ready for deployment 
and roll back to v17R6.


FWIW, this is a project (i.e., not binary) database. I'm not sure 
whether that is pertinent to this issue since, as mentioned above, it 
runs with no delay on 4D single-user.


Many thanks in advance.

-M


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

Longitude Index: B-Tree or Cluster

[John J Foster via 4D_Tech]

Hi All,

I have a GEO database of almost 5 million cities. They include various data and 
latitude and longitude.

I need to use the Longitude file in searches. To speed it up I need to index. 
Many of the values are similar like 141.235 or 141 3.23 and so on. So for those 
who might know would a Cluster index be better suited or a B-Tree?

Thanks,
John…

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

Re: NTK 32K limit in TCP Receive

[Douglas von Roeder via 4D_Tech]

Jeff:

Anecdotally, 4D IC is based on PDM’s Internet Tools which dates back to the
early 90’s (PDM was started by a few of the original ACI employees from the
80’s). Quite a bit of the code was updated but perhaps that’s one item
that’s not been up to speed…er, size.

--
Douglas von Roeder
949-910-4084


On Thu, Apr 9, 2020 at 1:28 PM Jeffrey Kain via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Nope, it's for real.
>
> Easy enough to loop, etc.. But it's a bit of an anachronism in a modern
> plug-in like NTK.
>
> > On Apr 9, 2020, at 4:24 PM, Ben Kershaw via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> >> Why? :)
> >> "The bufferSize parameter indicates the maximum number of bytes to
> read. If it is omitted or set to 0, the plugin will use the maximum size
> for a text variable (32000 bytes).”
> >
> > Have you tested it to make sure it’s not just a documentation error?
>
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Backup Settings Not Saving

[Pat Bensky via 4D_Tech]

I'm sure I reported this as a bug some time ago, and I'm sure I was
notified that it was fixed :) But I can't find the bug report and it has
not been fixed in the version I'm using (v17r6).
Pat

Pat

On Thu, 9 Apr 2020 at 23:46, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Hi Tom,
>
> Thanks for confirming. Yeah, it seems the other settings save correctly.
> Just this one.
>
> Interestingly, I found the following bug fix for v17.3:
>
> ACI0098925: "Backup settings do not save “Repeat after X
> seconds/minutes/hours” option: on Windows it is always 60 mn, on macOS it
> is always 0 mn (wich is worse because the 0 seconds will lead the backup
> log file to be flooded).” (https://bugs.4d.fr/fixedbugslist?Version=17.3)
>
> A little different, since I’m seeing 0 seconds after each save attempt on
> Windows as well. And if it was fixed for v17.3, I would have expected it to
> be working in v17.3 HF3, so that’s confusing. Maybe it wasn’t really fixed.
>
> Thanks for checking.
>
> --
> Cannon Smith
> Synergy Farm Solutions Inc.
> 
> 
>
> > On Apr 9, 2020, at 3:51 PM, Tom Benedict  wrote:
> >
> > I can confirm the same thing in 4D Server 17.3 Build 17.244600.
>
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Backup Settings Not Saving

[Cannon Smith via 4D_Tech]

Hi Tom,

Thanks for confirming. Yeah, it seems the other settings save correctly. Just 
this one.

Interestingly, I found the following bug fix for v17.3:

ACI0098925: "Backup settings do not save “Repeat after X seconds/minutes/hours” 
option: on Windows it is always 60 mn, on macOS it is always 0 mn (wich is 
worse because the 0 seconds will lead the backup log file to be flooded).” 
(https://bugs.4d.fr/fixedbugslist?Version=17.3)

A little different, since I’m seeing 0 seconds after each save attempt on 
Windows as well. And if it was fixed for v17.3, I would have expected it to be 
working in v17.3 HF3, so that’s confusing. Maybe it wasn’t really fixed.

Thanks for checking.

--
Cannon Smith
Synergy Farm Solutions Inc.



> On Apr 9, 2020, at 3:51 PM, Tom Benedict  wrote:
> 
> I can confirm the same thing in 4D Server 17.3 Build 17.244600.

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

Re: Backup Settings Not Saving

[Tom Benedict via 4D_Tech]

Hi Cannon,

I can confirm the same thing in 4D Server 17.3 Build 17.244600.

I find that I can change it from “Retry after x..” to “Retry at the next 
scheduled date and time” and it will save, though.

The 

> On Apr 9, 2020, at 14:33, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Sorry, that should have been 4D v17.3 HF3.
> 
> --
> Cannon Smith
> Synergy Farm Solutions Inc.
> 
> 
> 
>> On Apr 9, 2020, at 3:32 PM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> Anyone else seen this? Mac or Windows, v17 HF3.
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Backup Settings Not Saving

[Cannon Smith via 4D_Tech]

Sorry, that should have been 4D v17.3 HF3.

--
Cannon Smith
Synergy Farm Solutions Inc.



> On Apr 9, 2020, at 3:32 PM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Anyone else seen this? Mac or Windows, v17 HF3.

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

Backup Settings Not Saving

[Cannon Smith via 4D_Tech]

I just noticed that the “If backup fails… Retry after x [units]” backup setting 
is set to 0 Seconds on all my servers. It used to be 5 minutes. So I tried 
changing it back to 5 minutes and save. If I reopen the settings dialog, I see 
that it is still set to 0 seconds. The setting change isn’t being saved!

Anyone else seen this? Mac or Windows, v17 HF3.

Thanks for any help.

--
Cannon Smith
Synergy Farm Solutions Inc.



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

Re: NTK 32K limit in TCP Receive

[Jeffrey Kain via 4D_Tech]

Nope, it's for real.

Easy enough to loop, etc.. But it's a bit of an anachronism in a modern plug-in 
like NTK.

> On Apr 9, 2020, at 4:24 PM, Ben Kershaw via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
>> Why? :)
>> "The bufferSize parameter indicates the maximum number of bytes to read. If 
>> it is omitted or set to 0, the plugin will use the maximum size for a text 
>> variable (32000 bytes).”
> 
> Have you tested it to make sure it’s not just a documentation error?

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

Re: NTK 32K limit in TCP Receive

[Ben Kershaw via 4D_Tech]

Jeffrey Kain wrote:

>Why? :)
>"The bufferSize parameter indicates the maximum number of bytes to read. If it 
>is omitted or set to 0, the plugin will use the maximum size for a text 
>variable (32000 bytes).”

Have you tested it to make sure it’s not just a documentation error?

Regards,
Ben Kershaw
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: How to Verify Page Setup for a Form?

[Randy Kaempen via 4D_Tech]

> On Apr 9, 2020, at 11:43 AM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> when you upgrade to v18, the property will be available in JSON forms (export 
> structure, form convert to json) too.

Yes, but why was the PAGE SETUP command taken away?  Currently, the page size 
and orientation are stored in the form.  When you call PAGE SETUP, those values 
are restored.  Now we’re supposed to use SET PRINT OPTION to set each value 
individually?  Where will we get those from?  Now, when a form is changed, we 
have to adjust it on the form, then determine the new page size and 
orientation, and then hard code them in SET PRINT OPTION commands?  Sounds like 
a huge step backwards and a lot more work for us.:-(


Randy Kaempen
Intellex Corporation

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

NTK 32K limit in TCP Receive

[Jeffrey Kain via 4D_Tech]

Why? :)

"The bufferSize parameter indicates the maximum number of bytes to read. If it 
is omitted or set to 0, the plugin will use the maximum size for a text 
variable (32000 bytes)."
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: How to Verify Page Setup for a Form?

[Keisuke Miyako via 4D_Tech]

when you upgrade to v18, the property will be available in JSON forms (export 
structure, form convert to json) too.

2020/04/09 23:40、Tom Benedict via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
This is in v17.3 Windows.
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: How to Verify Page Setup for a Form?

[Tom Benedict via 4D_Tech]

I think I have discovered the answer to my question. I’ve found that the “Print 
Settings” property, in the Property List for the form, will display the Page 
Setup/Print Setup dialog with the ‘custom’ settings selected.

Tom

> On Apr 9, 2020, at 07:40, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Is there any way to ‘know’ by observation the PAGE SETUP details for a given 
> form?
> 
> I ask because I’m trying to verify that a given form was not inadvertently 
> changed by opening and saving it in the dev environment with a different 
> default printer.
> 
> For example, if I open a form, select “Page Setup” from the “File” menu, 
> select a printer, elect “Landscape”, click “OK” then Save the form, how can I 
> verify, short of executing code which uses that form, that my selections 
> ‘stick’?
> 
> This is in v17.3 Windows.
> 
> Thanks,
> 
> Tom Benedict
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: How to Verify Page Setup for a Form?

[Patrick Emanuel via 4D_Tech]

I would say "QS_Toolbox", form editor ;-)

Patrick



-
Patrick EMANUEL

Administrator
www.association-qualisoft.eu 
(Soft1002, Simply Asso & QS_Toolbox)
--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

How to Verify Page Setup for a Form?

[Tom Benedict via 4D_Tech]

Is there any way to ‘know’ by observation the PAGE SETUP details for a given 
form?

I ask because I’m trying to verify that a given form was not inadvertently 
changed by opening and saving it in the dev environment with a different 
default printer.

For example, if I open a form, select “Page Setup” from the “File” menu, select 
a printer, elect “Landscape”, click “OK” then Save the form, how can I verify, 
short of executing code which uses that form, that my selections ‘stick’?

This is in v17.3 Windows.

Thanks,

Tom Benedict
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

AW: CREATE DOCUMENT erors

[Epperlein, Lutz (agendo) via 4D_Tech]

Do you use an error handler with ON ERR CALL?

I've just tested it and I get an error -120 Tried to access a file by using a 
pathname that specifies a non-existing directory.
Or -54 Attempt to open locked file for writing.

Maybe your error from the error stack comes from an older one in this process?

Regards
Lutz


-Ursprüngliche Nachricht-
Betreff: CREATE DOCUMENT erors

Using v17:

How can I find out exactly what the error is when CREATE DOCUMENT fails?
EG: disk full, pathname invalid, document already exists and can't be
deleted, etc.
I tried calling GET LAST ERROR STACK and the error it returned was 39 "The
set does not exist" which is clearly inappropriate.

Pat

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

CREATE DOCUMENT erors

[Pat Bensky via 4D_Tech]

Using v17:

How can I find out exactly what the error is when CREATE DOCUMENT fails?
EG: disk full, pathname invalid, document already exists and can't be
deleted, etc.
I tried calling GET LAST ERROR STACK and the error it returned was 39 "The
set does not exist" which is clearly inappropriate.

Pat

-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**