Re: Longitude Index: B-Tree or Cluster

> On 11 Apr 2020, at 12:24 AEST, John J Foster via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Couldn’t find anything in KB. Here is the post from 155 month and 19 days ago mentioned in the other post: But someone might think the following could be of some help, sorry its not 4D-code.

Re: Longitude Index: B-Tree or Cluster

Hi John, > On 11 Apr 2020, at 12:24 AEST, John J Foster via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Yes I understand all that and use the longitude to calculate MGT offsets and > Latitiudes for Declinations and so on … > > I am fixing data - matching one set imported data from another

Re: Longitude Index: B-Tree or Cluster

Hi Jörg, Yes I understand all that and use the longitude to calculate MGT offsets and Latitiudes for Declinations and so on … I am fixing data - matching one set imported data from another source - and I also realize that I could use a good proximity routine (using the lon/lat and a distance

Re: Longitude Index: B-Tree or Cluster

The Google tells me that you are located in Coffs Harbour, New South Wales, Australia > Exercise: > Name the town where I’m located when my position is: > > - 30.30225° 153.1086° > ** 4D Internet Users Group (4D iNUG)

Re: Longitude Index: B-Tree or Cluster

G’day John, > On 10 Apr 2020, at 10:03 AEST, John J Foster via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Many of the values are similar like 141.235 or 141 3.23 and so on. Have a look at a world map with a grid and consider this: Geodata are shown in degrees and fractions of it and can be

Re: NTK 32K limit in TCP Receive

Yeah, can you imagine how they could have sold and marketed 4D with A4D built in? Nothing on the market would have come close. > On Apr 10, 2020, at 5:03 PM, James Wright via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > So should Active4D!

Re: NTK 32K limit in TCP Receive

So should Active4D! On Fri, 10 Apr 2020 at 21:58, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> wrote: > :) > > I miss the days of lots of thriving plug-ins. NTK should really be built > into 4D. > > > On Apr 10, 2020, at 4:49 PM, Aparajita Fishman via 4D_Tech < > 4d_tech@lists.4d.com> wrote:

Re: NTK 32K limit in TCP Receive

:) I miss the days of lots of thriving plug-ins. NTK should really be built into 4D. > On Apr 10, 2020, at 4:49 PM, Aparajita Fishman via 4D_Tech > <4d_tech@lists.4d.com> wrote: > >> Overreact much? > > Yes, I do. All the time unfortunately. > > We plugin authors are a dying breed. I plead

Re: NTK 32K limit in TCP Receive

>> The documentation clearly says 32000 is the default maximum to read if you >> **DON’T** specify the maximum. So I have to agree with Rob — what exactly is >> the problem? Is it really so difficult to type a few more characters to >> override the default? > > You can specify a larger maximum

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

There’s a good article on the 4D Blog describing pros and cons of binary and Project Mode: https://blog.4d.com/binary-database-vs-project-database/ At the bottom of the post in the “Con” section it mentions: Development with

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

Tim, This is great info. Thanks for testing it out. On Fri, Apr 10, 2020 at 10:57 AM Tim Nevels via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I also tested editing the text of a method with TextEdit while the Project > was open on 4D Server. The method was not open with 4D Remote. In fact no > 4D

Re: Configure 4D server as Windows Service on Windows Server 2016

Hi Tim, The OPEN ADMINISTRATION WINDOW command can be called by any client to view the Server UI. I believe you can even launch client on the server machine where the service is running. (You do have have Designer or Administrator access though.) HTH, Tom Benedict > On Apr 10, 2020, at

Re: Longitude Index: B-Tree or Cluster

Hey Kirk, Yea I have been mulling as a possibility. But I really want to put 4D through it’s motions first. Not worried about storage at this time as this is kind of a laboratory for testing large tables. Thanks for your ideas! John... > If absolute raw speed is what you are looking for I

RE: Configure 4D server as Windows Service on Windows Server 2016

Tim, We have created an interface which uses the OPEN ADMINISTRATION WINDOW command. This interface is provided to Admin's and accessible via the 4D Client connection. Although this does not give you complete access to every Admin Tool, it generally is enough for normal usage when running as

Configure 4D server as Windows Service on Windows Server 2016

Hello, We are having trouble being able to manage a 4D server (v18.2) on Windows Server 2016 when the 4D server Windows service is set up to run under a Local System account. The interactive service window never shows up. I understand that Microsoft has turned off the Interactive Service window

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

On Apr 10, 2020, at 12:09 PM, Kirk Brooks wrote: > This is what I found also. Thinking about it you can see how it makes sense > - a Project is simply a collection of text files. They can be edited by 4D > Method Editor or a text editor at the same time. On your local machine > that's manageable,

Re: NTK 32K limit in TCP Receive

> On Apr 10, 2020, at 1:09 PM, Aparajita Fishman via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > The documentation clearly says 32000 is the default maximum to read if you > **DON’T** specify the maximum. So I have to agree with Rob — what exactly is > the problem? Is it really so difficult

Re: NTK 32K limit in TCP Receive

> On 10 Apr 2020, at 18:03, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > First, the maximum size of a text variable isn't 32000 bytes anymore, which > leads me to believe this was an oversight and not a feature... :) Yes, I know. But it’s not related. It is just a convenient

Re: NTK 32K limit in TCP Receive

>> On 9 Apr 2020, at 20:46, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com >> > wrote: >> >> Why? :) > > Why not? > > The data that is available from the stream can be any arbitrary size. The > plugin does not know upfront how many bytes are available, so it needs

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

This is what I found also. Thinking about it you can see how it makes sense - a Project is simply a collection of text files. They can be edited by 4D Method Editor or a text editor at the same time. On your local machine that's manageable, desirable, but on the server it would be a nightmare. I

Re: CREATE DOCUMENT erors

Hi Lutz, Thanks for the suggestion ... it seems that GET LAST ERROR STACK only works when called from within an error handler method. I hadn't realised that. Previously I was calling it from the method that was trying to create the file. Pat On Thu, 9 Apr 2020 at 11:44, Epperlein, Lutz (agendo)

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

On 4/10/2020 8:50 AM, Tim Nevels via 4D_Tech wrote: I can confirm that v18.1 4D Server can open an uncompiled Project database and users can connect to it and it appears to work. You can get into Design mode and open the structure, methods and forms but you can't make changes to them. You

Re: NTK 32K limit in TCP Receive

Two problems; First, the maximum size of a text variable isn't 32000 bytes anymore, which leads me to believe this was an oversight and not a feature... :) Second, it was easy to receive text until a stop character is received, as long as the data is less than 32K. When your packets become

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

On Apr 10, 2020, at 9:38 AM, M wrote: > Well, your question promoted me to re-convert the database on the server > host. Previously I had converted to v18.1 on my desktop development > machine and also converted from binary to project database. So, I have > now opened a fresh copy of the v17R6

Re: Longitude Index: B-Tree or Cluster

John, If absolute raw speed is what you are looking for I would break each value into whole numbers - the integer and the decimal and store them separately as longints. Index the integer with a b-tree and the decimal with a cluster. You sacrifice space (maybe - haven't really done the math on 2

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

Whoops. I missed the part about it running in interpreted mode. So please disregard my comments about .4DZ. Tom Benedict > On Apr 10, 2020, at 08:02, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > On Apr 10, 2020, at 07:28, 4dinug via 4D_Tech <4d_tech@lists.4d.com> wrote: > >>

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

Sorry if I missed it, but I still did not see in your messages that you reproduced the slow startup with conversion on a separate non-VM machine. Also wondering if there is any difference between 4D single user and 4D Server. I have not used 4D Server to convert structures to project mode. I

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

On Apr 10, 2020, at 07:28, 4dinug via 4D_Tech <4d_tech@lists.4d.com> wrote: > >So, my conclusion is that converting the database to a v18 project database is >the performance killer. Which is mildly annoying, because the project database >>format was a most significant reason why I wanted to

Re: Longitude Index: B-Tree or Cluster

Hi Tom, I didn’t give a complete scenario which is why the example looks so broad. In this case I have imported data to which I need to match with the correct Olson Time Zone. So in the example searching for Russia (RU) and then the longitude range returns many many records (aka, broad).

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

On 4/10/2020 6:18 AM, John DeSoi via 4D_Tech wrote: Have you tried it using binary mode to see if there is any difference? Is there anything unusual about your project, e.g. a really large number of methods or forms? You get the same results on different computers? Is it a regular server or a

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

On 4/9/2020 10:24 PM, Keisuke Miyako via 4D_Tech wrote: Thank you for your reply. 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

Re: Longitude Index: B-Tree or Cluster

John, Make sure you include testing a single query, if you haven’t already, then see what 4D’s query analyzer does with it in the query plan. Your current use of two queries may very well be optimal for your data set, since most countries don’t span much of the world in terms of longitude.

Re: Backup Settings Not Saving

Thanks, Pat. I’ll report it again today. -- Cannon Smith Synergy Farm Solutions Inc. > On Apr 9, 2020, at 5:25 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > 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

Re: Longitude Index: B-Tree or Cluster

Hi Arnaud, Just noticed that the search was typed in wrong. It should be: QUERY([City];[City]country code=$cntryCode) QUERY SELECTION([City];[City]longitude>=$lon_r;*) QUERY SELECTION([City]; & ;[City]longitude<=$lon_r+1) John… > In this case I am searching by

Re: Longitude Index: B-Tree or Cluster

Hi Arnaud, > what is the field type? The field type is a real number. There are so many similar values in terms of the integer part but many many variations of the decimal part. Currently I am using a B-Tree index. I’ve thought about breaking it the two parts but that just adds an extra

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

Have you tried it using binary mode to see if there is any difference? Is there anything unusual about your project, e.g. a really large number of methods or forms? You get the same results on different computers? Is it a regular server or a merged server application? I assume your application

Re: NTK 32K limit in TCP Receive

> On 9 Apr 2020, at 20:46, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Why? :) Why not? The data that is available from the stream can be any arbitrary size. The plugin does not know upfront how many bytes are available, so it needs a limit. There is a default value, which

Re: Longitude Index: B-Tree or Cluster

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