Re: Longitude Index: B-Tree or Cluster

[Bernard Escaich via 4D_Tech]

John,

You say "Show me all cities within 4 minutes from this longitude/latitude."

I propose to search in a square around your location, ie make a search lat +- 4 
miles and long +- 4 miles.
You will get a few occurrences and then refine the search to a circle with 
geodesic functions.

Cordialement,

Bernard Escaich



> Le 14 avr. 2020 à 23:22, John J Foster via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> Hey Peter,
> 
> I have already added and split out the longitude into separates fields. So I 
> have the original longitude as a real and I have it separated into two other 
> fields.
> 
> There are only 360 integer longitudes (ignoring the decimal part) possible. 
> Potentially -180 through +180. In this case Cluster index seems appropriate 
> in theory. The separated text field that look like this: “-117”, “-047”, 
> “+002”, etc. And there are over 4.7 million records.
> 
> Here’s a few example there are:
> 
> “-117” -> 2,034
> “-047” -> 2,658
> “+002” -> 14,217
> “+045” -> 21,255
> and so on …
> 
> Staring with prefix:
> “+” -> 3,740,510
> “-“ -> 954,774
> 
> Almost 4 times as many “+” prefixed records.
> 
> I can affirm that searching by the longitude field as a real (indexed as 
> b-tree) is slower on the first pass taking a few seconds. In fact the search 
> requires multiple lines to find a search where longitude returns all -117 and 
> thus requires a longitude search between -117 and -118.
> 
> But after that first query it seems quite fast like a 1/2 second or so. 
> Likely because the index has been loaded.
> 
> I am not seeing any great speed differences between the pure real and the 
> longitude degree as text.
> 
>> So my advice would be to go for representation of position with reals and 
>> use standard index. Although speed difference may be small for middle-size 
>> data (how many locations there may be?)
> 
> 
> Over 4.7 million records.
> 
> I’ll keep experimenting and see which one, if any, seems acceptable.
> 
> Appreciate,
> John…
> 
> 
>> On Apr 14, 2020, at 1:22 PM, Peter Bozek  wrote:
>> 
>> John,
>> 
>> I do not think using text for dat that can be represented by number is a 
>> good idea. It require more memory - do not forget that Unicode uses 2 bytes 
>> for each character - and manipulation of bigger data structures is slower, 
>> but, especially, string manipulation, including comparison, depends on a 
>> locale, and is using a build-in ICU library. It means that, instead of 
>> comparing two numbers, you have all the overhead of calling a library 
>> function that applies potentially multi-pass comparison algorithm using 
>> mapping tables to two strings. Definitely, much slower.
>> 
>> Second, regarding standard and cluster index: as I understand it - and I may 
>> be wrong, 4D in general does not publish technical info - B-Trees (there are 
>> several types of them) offer optimal performance when result of search 
>> contains few records, can well do a range search, as traversing the tree is 
>> reasonably fast, but may be less effective when returning a big selection, 
>> as building a selection can be time consuming. How much slower depends, but 
>> IMHO it will be still pretty fast, unless the selection is huge.
>> 
>> Cluster index is suitable when the result of search is a (potentially large) 
>> selection. While B-tree node stores a reference to a record, Cluster index 
>> node stores a selection, so no selection building is needed. However, if I 
>> would design such an index, I would use hash table for cluster index. Hash 
>> table is much faster when you need to find one particular value, but is 
>> totally unsuitable for range searches, as it cannot be effectively 
>> traversed. That make a perfect sense for foreign key indexes - when loading 
>> 1-record, you have immediately a selection of N-records available, and you 
>> (almost) never do a search for range of foreign keys (with UUID keys, such 
>> search would not make any sense.)
>> 
>> So my advice would be to go for representation of position with reals and 
>> use standard index. Although speed difference may be small for middle-size 
>> data (how many locations there may be?)
>> 
>> HTH,
>> 
>> Peter Bozek
>> 
>> On Tue, Apr 14, 2020 at 9:17 PM John J Foster via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> Hi Arnaud,
>> 
>> I have split out the longitudes into a text and real component. I have 
>> formatted the longitudes as “000” and if west of GMT prefixed with “-“ and 
>> if east prefixed with “+“. I'll do something similar with latitudes and then 
>> try building some radial searches and see.
>> 
>> Since all string is text is there a still a way to tell 4D that a field and 
>> thus an index is a fixed size?
>> 
>> Anyway we shall see if theory and implementation matches!
>> 
>> Appreciate,
>> John…
>> 
>> 
>> 
>>> On Apr 14, 2020, at 12:00 PM, 4d_tech-requ...@lists.4d.com wrote:
>>> 
>>> From: Arnaud de Montard mailto:arn...@init5.fr>>
>>> Subject: Re: Longitude Index: B-Tree or Cluster

Re: Simple find and replace in 4D Write Pro.

[Bernard Escaich via 4D_Tech]

Luc,

For Find and replace, try this method


Reference inside

Cordialement,

Bernard Escaich



> Le 14 avr. 2020 à 22:36, Luc Devar via 4D_Tech <4d_tech@lists.4d.com> a écrit 
> :
> 
> I am still using 4Dwrite and need to eventually convert to 4DwritePro but did 
> not find the time to start this yet. I have a process on the server ( 64 
> bits) that send email containing a 4Dwrite document. Since I am on 64 bits.  
> I cannot use any of the old 4D write command. So I am converting my 4Dwrite 
> template to 4DwritePro and this worked just fine.
> 
> wpArea:=WP New([EMAIL_TEMPLATE]TEMPLATE_) 
> ST SET OPTIONS(wpArea;ST Expressions display mode;ST Values)
> WP EXPORT VARIABLE(wpArea;$str;wk mime html)
> 
> Now I want to simply find and replace some text in the 4DwritePro document 
> before exporting in mime html. I am looking for a simple find and replace (WR 
> find in the old 4D write). I have spent more than 2 hours trying to find a 
> way with the documentation without success. I know this should be obvious but 
> cannot find it. So I am asking for help as I cannot lose all this time on a 
> simple command. 
> 
> Also anyone can anyone refer me a good and complete 4DwritePro example so I 
> can learn a bit quicker. Learning from the documentation is simply a waste of 
> time.
> 
> Luc Devar
> Thanks,
> 
> **
> 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: Longitude Index: B-Tree or Cluster

[Charles Miller via 4D_Tech]

Should have been search

On Tue, Apr 14, 2020 at 5:33 PM John J Foster via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hey Chuck,
>
> Not sure what “hash and stir” means?
>
> Matching data requires one kind of index for speed and doing a radial
> search another.
>
> In the db where I only have 1/2 million records with longitude as a real
> the index returns a range quite quickly. So I’ll keep it for the radial
> search.
>
> For matching the data the jury is still out.
>
> Appreciate,
> John…
>
>
> > Sure you hash and stir that, when searching for a particular lat/long
> combination you has entry and search
> >
> > This will not help in distance calculations
> >
> > How about this for a create a concatenated key that has two parts for
> each
> >
> > Named LatKey
> >   Lat_before decimal
> >   Lat_after decimal
> >
> > LongKey
> >   Long_before decimal
> >   long_after decimal
> >
> > do queries
> > and process using fields that contain the entire lat and long as a real
> >
> > Regards
> >
> > Chuck
>
> **
> 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
> **

-- 
-
 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 Server connectivity
  https://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)
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: Longitude Index: B-Tree or Cluster

[John J Foster via 4D_Tech]

Hey Chuck,

Not sure what “hash and stir” means?

Matching data requires one kind of index for speed and doing a radial search 
another.

In the db where I only have 1/2 million records with longitude as a real the 
index returns a range quite quickly. So I’ll keep it for the radial search.

For matching the data the jury is still out.

Appreciate,
John…


> Sure you hash and stir that, when searching for a particular lat/long 
> combination you has entry and search
> 
> This will not help in distance calculations  
> 
> How about this for a create a concatenated key that has two parts for each
> 
> Named LatKey
>   Lat_before decimal
>   Lat_after decimal
> 
> LongKey
>   Long_before decimal
>   long_after decimal
> 
> do queries 
> and process using fields that contain the entire lat and long as a real
> 
> Regards
> 
> Chuck

**
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: Longitude Index: B-Tree or Cluster

[John J Foster via 4D_Tech]

Hey Peter,

I have already added and split out the longitude into separates fields. So I 
have the original longitude as a real and I have it separated into two other 
fields.

There are only 360 integer longitudes (ignoring the decimal part) possible. 
Potentially -180 through +180. In this case Cluster index seems appropriate in 
theory. The separated text field that look like this: “-117”, “-047”, “+002”, 
etc. And there are over 4.7 million records.

Here’s a few example there are:

“-117” -> 2,034
“-047” -> 2,658
“+002” -> 14,217
“+045” -> 21,255
and so on …

Staring with prefix:
“+” -> 3,740,510
“-“ -> 954,774

Almost 4 times as many “+” prefixed records.

I can affirm that searching by the longitude field as a real (indexed as 
b-tree) is slower on the first pass taking a few seconds. In fact the search 
requires multiple lines to find a search where longitude returns all -117 and 
thus requires a longitude search between -117 and -118.

But after that first query it seems quite fast like a 1/2 second or so. Likely 
because the index has been loaded.

I am not seeing any great speed differences between the pure real and the 
longitude degree as text.

> So my advice would be to go for representation of position with reals and use 
> standard index. Although speed difference may be small for middle-size data 
> (how many locations there may be?)


Over 4.7 million records.

I’ll keep experimenting and see which one, if any, seems acceptable.

Appreciate,
John…


> On Apr 14, 2020, at 1:22 PM, Peter Bozek  wrote:
> 
> John,
> 
>  I do not think using text for dat that can be represented by number is a 
> good idea. It require more memory - do not forget that Unicode uses 2 bytes 
> for each character - and manipulation of bigger data structures is slower, 
> but, especially, string manipulation, including comparison, depends on a 
> locale, and is using a build-in ICU library. It means that, instead of 
> comparing two numbers, you have all the overhead of calling a library 
> function that applies potentially multi-pass comparison algorithm using 
> mapping tables to two strings. Definitely, much slower.
> 
> Second, regarding standard and cluster index: as I understand it - and I may 
> be wrong, 4D in general does not publish technical info - B-Trees (there are 
> several types of them) offer optimal performance when result of search 
> contains few records, can well do a range search, as traversing the tree is 
> reasonably fast, but may be less effective when returning a big selection, as 
> building a selection can be time consuming. How much slower depends, but IMHO 
> it will be still pretty fast, unless the selection is huge.
> 
> Cluster index is suitable when the result of search is a (potentially large) 
> selection. While B-tree node stores a reference to a record, Cluster index 
> node stores a selection, so no selection building is needed. However, if I 
> would design such an index, I would use hash table for cluster index. Hash 
> table is much faster when you need to find one particular value, but is 
> totally unsuitable for range searches, as it cannot be effectively traversed. 
> That make a perfect sense for foreign key indexes - when loading 1-record, 
> you have immediately a selection of N-records available, and you (almost) 
> never do a search for range of foreign keys (with UUID keys, such search 
> would not make any sense.)
> 
> So my advice would be to go for representation of position with reals and use 
> standard index. Although speed difference may be small for middle-size data 
> (how many locations there may be?)
> 
> HTH,
> 
> Peter Bozek
> 
> On Tue, Apr 14, 2020 at 9:17 PM John J Foster via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> Hi Arnaud,
> 
> I have split out the longitudes into a text and real component. I have 
> formatted the longitudes as “000” and if west of GMT prefixed with “-“ and if 
> east prefixed with “+“. I'll do something similar with latitudes and then try 
> building some radial searches and see.
> 
> Since all string is text is there a still a way to tell 4D that a field and 
> thus an index is a fixed size?
> 
> Anyway we shall see if theory and implementation matches!
> 
> Appreciate,
> John…
> 
> 
> 
> > On Apr 14, 2020, at 12:00 PM, 4d_tech-requ...@lists.4d.com wrote:
> > 
> > From: Arnaud de Montard mailto:arn...@init5.fr>>
> > Subject: Re: Longitude Index: B-Tree or Cluster
> > Date: April 14, 2020 at 2:23:26 AM PDT
> > To: 4D iNug Technical <4d_tech@lists.4d.com >
> > 
> > 
> > 
> >> Le 13 avr. 2020 à 19:36, Bernard Escaich via 4D_Tech <4d_tech@lists.4d.com 
> >> > a écrit :
> >> 
> >> Hi John,
> >> 
> >> From the top of my head, indexes on long are less efficient than on text 
> >> values ; I have a doubt, perhaps only for updating.
> > 
> > I'd think the opposite, an index based on a "fixed length" field is always 
> > more efficient (search, update…) than one based on a 

Re: Longitude Index: B-Tree or Cluster

[Tim Nevels via 4D_Tech]

On Apr 14, 2020, at 3:39 PM, Peter Bozek wrote:

> Cluster index is suitable when the result of search is a (potentially
> large) selection. While B-tree node stores a reference to a record, Cluster
> index node stores a selection, so no selection building is needed. However,
> if I would design such an index, I would use hash table for cluster index.
> Hash table is much faster when you need to find one particular value, but
> is totally unsuitable for range searches, as it cannot be effectively
> traversed. That make a perfect sense for foreign key indexes - when loading
> 1-record, you have immediately a selection of N-records available, and you
> (almost) never do a search for range of foreign keys (with UUID keys, such
> search would not make any sense.)

Many years ago at a 4D Summit I remember someone asking Laurent a question of 
how Cluster B-Tree indexes were implemented. He gave a fairly detailed answer. 

Cluster B-Tree indexes are a B-Tree index, but there is only 1 node for each 
index value. The data in the node can be several different things. 

- It could be a reference to a single record like you would have in a 
traditional B-Tree index. It’s just a record number. 

- If the node is for 2 or more records, an array of record numbers is stored in 
the node. He made a point of saying it is the same ARRAY LONGINT just like we 
have in the language, so 4 bytes per record.

- At some point — he didn’t go into when it would happen — 4D switches from an 
array of record numbers to a set of records. He said it’s the same type of 4D 
set that we have in the language where you have 1 bit representing each record 
that is included in the set, and all the size optimizations they do for sets 
using compression and whatever. 

The idea is to try and balance speed of converting that list of records — 
whether it is an array of record numbers or a set — and the amount of storage 
needed for the node.

So when you do a typical query using a Cluster B-Tree you get a single node. If 
the node is for 1 record is is just as fast to retrieve the record as with a 
normal B-Tree index. If the node contains an array of 10 records numbers, then 
the array is used to retrieve the 10 records and create a selection. 

But if the node contains a lot of record — who know exactly how many “a lot” is 
— then a set is used to create the selection of records. And that is very fast 
and efficient. That’s why a Cluster B-Tree index on a boolean field is always 
super fast for 10,000 records or 1,000,000 records. Using sets makes it very 
fast to build that selection as compared to using a normal B-Tree index where 
you would have to walk 10,000 nodes or 1,000,000 nodes of the tree to build of 
the selection. 

Also Cluster B-Tree indexes reduces the need to rebalance the tree as new 
records are added to the table since it usually just adds data to an existing 
node rather than always adding a new node for each new record.

Tim

*
Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.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: Longitude Index: B-Tree or Cluster

[Chuck Miller via 4D_Tech]

Sure you hash and stir that, when searching for a particular lat/long 
combination you has entry and search

This will not help in distance calculations  

How about this for a create a concatenated key that has two parts for each

Named LatKey
Lat_before decimal
Lat_after decimal

LongKey
Long_before decimal
long_after decimal

do queries 
and process using fields that contain the entire lat and long as a real

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  

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. 

> On Apr 14, 2020, at 3:24 PM, John J Foster via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Arnaud,
> 
> Hmmm...
> 
> I think I would like the data to be obvious to my eyes when I look at it.
> 
> My initial goal was simply to be able to match up a location with a missing 
> Olson Timezone ID. Import the data, fix the data in the much larger db, and 
> then export it back out to reimport into it’s source db. The imported data 
> will always be a much smaller subset (at this time).
> 
> Then I realized that having the ability to do a radial search would be nice.  
> Show me all cities within 4 minutes from this longitude/latitude. So being 
> able to search quickly is important.
> 
> So all of this work is for those two needs.
> 
> Anyway, appreciate,
> John…
> 
> 
>>> Le 13 avr. 2020 à 23:51, John J Foster via 4D_Tech <4d_tech@lists.4d.com 
>>> > a écrit :
>>> 
>>> Hey Bernard,
>>> 
>>> I would use text values if I didn’t think I needed to do range searches. 
>>> It’s not a “live” db so I can play and experiment to my hearts content.
>> 
>> Considering 5 million pairs of long/lat values is a lot, I'd first try to 
>> see if I can store values in a different field type than a real. Examples:
>> - integer or longint : multiply by 10^x and remove decimals; depends on the 
>> number of digits you need to keep (example, Lat,Long=48.862725,2.28759 
>> becomes 48862725,2287590)
>> - uuid: no limit about the encoded number, but I don't know if performances 
>> are better than real
>> 
>> -- 
>> 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
> **

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

Simple find and replace in 4D Write Pro.

[Luc Devar via 4D_Tech]

I am still using 4Dwrite and need to eventually convert to 4DwritePro but did 
not find the time to start this yet. I have a process on the server ( 64 bits) 
that send email containing a 4Dwrite document. Since I am on 64 bits.  I cannot 
use any of the old 4D write command. So I am converting my 4Dwrite template to 
4DwritePro and this worked just fine.

wpArea:=WP New([EMAIL_TEMPLATE]TEMPLATE_)   
ST SET OPTIONS(wpArea;ST Expressions display mode;ST Values)
WP EXPORT VARIABLE(wpArea;$str;wk mime html)

Now I want to simply find and replace some text in the 4DwritePro document 
before exporting in mime html. I am looking for a simple find and replace (WR 
find in the old 4D write). I have spent more than 2 hours trying to find a way 
with the documentation without success. I know this should be obvious but 
cannot find it. So I am asking for help as I cannot lose all this time on a 
simple command. 

Also anyone can anyone refer me a good and complete 4DwritePro example so I can 
learn a bit quicker. Learning from the documentation is simply a waste of time.

Luc Devar
Thanks,

**
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: one server window on client

[Chuck Miller via 4D_Tech]

I did not, but this happens with multiple connection types and points, but will 
try and advise but not today

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  

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. 

> On Apr 14, 2020, at 4:25 PM, lists via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Did you try clearing the local resources and start over?, we have had 
> unexplained issues on specific machines that went away when we started fresh.
> 
> Lahav

**
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: one server window on client

[lists via 4D_Tech]

Did you try clearing the local resources and start over?, we have had 
unexplained issues on specific machines that went away when we started fresh.

Lahav



-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Charles Miller via 
4D_Tech
Sent: Tuesday, April 14, 2020 2:06 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Charles Miller 
Subject: Re: one server window on client

I have tried that as well. I added change user after trying to log in as 
designer. Result crash. Logging in as administrator. Result crash. Change user. 
Result crash

Regards

Chuck

On Tue, Apr 14, 2020 at 3:47 PM Tim Nevels via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> On Apr 14, 2020, at 2:00 PM, Chuck Miller wrote:
>
> > Environment windows server 2016. 4D 17.4 running as a built server.
> Server running as a service.
> >
> > I am logged in as Administrator.
> >
> > A one line method
> > OPEN ADMINISTRATION WINDOW
> >
> > 4D crashes every time
> >
> > I have changed method to add change user crashes in the same place
> >
> > Any ideas
>
> Try “Designer" user. That’s how I always access the 4D Server window 
> from 4D Client.
>
> Start a new process, then:
>
> CHANGE CURRENT USER(“Designer”;”password”) OPEN ADMINISTRATION WINDOW
>
> When I’m done, I switch back to the previous 4D user.
>
> Tim
>
> *
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> timnev...@mac.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
> **

--
-
 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 Server connectivity
  https://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)
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: Longitude Index: B-Tree or Cluster

[Peter Bozek via 4D_Tech]

John,

 I do not think using text for dat that can be represented by number is a
good idea. It require more memory - do not forget that Unicode uses 2 bytes
for each character - and manipulation of bigger data structures is slower,
but, especially, string manipulation, including comparison, depends on a
locale, and is using a build-in ICU library. It means that, instead of
comparing two numbers, you have all the overhead of calling a library
function that applies potentially multi-pass comparison algorithm using
mapping tables to two strings. Definitely, much slower.

Second, regarding standard and cluster index: as I understand it - and I
may be wrong, 4D in general does not publish technical info - B-Trees
(there are several types of them) offer optimal performance when result of
search contains few records, can well do a range search, as traversing the
tree is reasonably fast, but may be less effective when returning a big
selection, as building a selection can be time consuming. How much slower
depends, but IMHO it will be still pretty fast, unless the selection is
huge.

Cluster index is suitable when the result of search is a (potentially
large) selection. While B-tree node stores a reference to a record, Cluster
index node stores a selection, so no selection building is needed. However,
if I would design such an index, I would use hash table for cluster index.
Hash table is much faster when you need to find one particular value, but
is totally unsuitable for range searches, as it cannot be effectively
traversed. That make a perfect sense for foreign key indexes - when loading
1-record, you have immediately a selection of N-records available, and you
(almost) never do a search for range of foreign keys (with UUID keys, such
search would not make any sense.)

So my advice would be to go for representation of position with reals and
use standard index. Although speed difference may be small for middle-size
data (how many locations there may be?)

HTH,

Peter Bozek

On Tue, Apr 14, 2020 at 9:17 PM John J Foster via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi Arnaud,
>
> I have split out the longitudes into a text and real component. I have
> formatted the longitudes as “000” and if west of GMT prefixed with “-“ and
> if east prefixed with “+“. I'll do something similar with latitudes and
> then try building some radial searches and see.
>
> Since all string is text is there a still a way to tell 4D that a field
> and thus an index is a fixed size?
>
> Anyway we shall see if theory and implementation matches!
>
> Appreciate,
> John…
>
>
>
> > On Apr 14, 2020, at 12:00 PM, 4d_tech-requ...@lists.4d.com wrote:
> >
> > From: Arnaud de Montard mailto:arn...@init5.fr>>
> > Subject: Re: Longitude Index: B-Tree or Cluster
> > Date: April 14, 2020 at 2:23:26 AM PDT
> > To: 4D iNug Technical <4d_tech@lists.4d.com  >>
> >
> >
> >
> >> Le 13 avr. 2020 à 19:36, Bernard Escaich via 4D_Tech <
> 4d_tech@lists.4d.com > a écrit :
> >>
> >> Hi John,
> >>
> >> From the top of my head, indexes on long are less efficient than on
> text values ; I have a doubt, perhaps only for updating.
> >
> > I'd think the opposite, an index based on a "fixed length" field is
> always more efficient (search, update…) than one based on a "variable
> length" field.
> >
> > --
> > 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
> **



-- 
--

Peter Bozek
**
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: one server window on client

[Charles Miller via 4D_Tech]

I have tried that as well. I added change user after trying to log in as
designer. Result crash. Logging in as administrator. Result crash. Change
user. Result crash

Regards

Chuck

On Tue, Apr 14, 2020 at 3:47 PM Tim Nevels via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> On Apr 14, 2020, at 2:00 PM, Chuck Miller wrote:
>
> > Environment windows server 2016. 4D 17.4 running as a built server.
> Server running as a service.
> >
> > I am logged in as Administrator.
> >
> > A one line method
> > OPEN ADMINISTRATION WINDOW
> >
> > 4D crashes every time
> >
> > I have changed method to add change user crashes in the same place
> >
> > Any ideas
>
> Try “Designer" user. That’s how I always access the 4D Server window from
> 4D Client.
>
> Start a new process, then:
>
> CHANGE CURRENT USER(“Designer”;”password”)
> OPEN ADMINISTRATION WINDOW
>
> When I’m done, I switch back to the previous 4D user.
>
> Tim
>
> *
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> timnev...@mac.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
> **

-- 
-
 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 Server connectivity
  https://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)
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: one server window on client

[Tim Nevels via 4D_Tech]

On Apr 14, 2020, at 2:00 PM, Chuck Miller wrote:

> Environment windows server 2016. 4D 17.4 running as a built server. Server 
> running as a service.
> 
> I am logged in as Administrator.
> 
> A one line method
> OPEN ADMINISTRATION WINDOW
> 
> 4D crashes every time
> 
> I have changed method to add change user crashes in the same place
> 
> Any ideas

Try “Designer" user. That’s how I always access the 4D Server window from 4D 
Client.

Start a new process, then:

CHANGE CURRENT USER(“Designer”;”password”)
OPEN ADMINISTRATION WINDOW
 
When I’m done, I switch back to the previous 4D user.

Tim

*
Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.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: one server window on client

[Charles Miller via 4D_Tech]

Yes on a client. not on the server

On Tue, Apr 14, 2020 at 3:25 PM lists via 4D_Tech <4d_tech@lists.4d.com> wrote:
>
> Chuck,
>
> Just to make sure, you are executing that command on a client, not on the 
> server with a stored proc or Execute on server right?
>
> Lahav
>
> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Charles Miller via 
> 4D_Tech
> Sent: Tuesday, April 14, 2020 1:17 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Charles Miller 
> Subject: Re: one server window on client
>
> Tried that with same result
>
> On Tue, Apr 14, 2020 at 3:15 PM Bob Miller via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> > Hi Chuck,
> >
> > RE> A one line method
> > RE> OPEN ADMINISTRATION WINDOW
> >
> > RE> 4D crashes every time
> >
> > What if you open a new process method with the one line?
> >
> > I call OPEN ADMINISTRATION WINDOW and it does work, but I have it in
> > its own process.  Can't say why other than that's how I wrap all my
> > primary methods.
> >
> > Bob Miller
> > Parker Hannifin Corp.
> > **
> > 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
> > **
>
> --
> -
>  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 Server connectivity
>   https://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)
> 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
> **



-- 
-
 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 Server connectivity
  https://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)
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: one server window on client

[lists via 4D_Tech]

Chuck,

Just to make sure, you are executing that command on a client, not on the 
server with a stored proc or Execute on server right?

Lahav

-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Charles Miller via 
4D_Tech
Sent: Tuesday, April 14, 2020 1:17 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Charles Miller 
Subject: Re: one server window on client

Tried that with same result

On Tue, Apr 14, 2020 at 3:15 PM Bob Miller via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Hi Chuck,
>
> RE> A one line method
> RE> OPEN ADMINISTRATION WINDOW
>
> RE> 4D crashes every time
>
> What if you open a new process method with the one line?
>
> I call OPEN ADMINISTRATION WINDOW and it does work, but I have it in 
> its own process.  Can't say why other than that's how I wrap all my 
> primary methods.
>
> Bob Miller
> Parker Hannifin Corp.
> **
> 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
> **

--
-
 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 Server connectivity
  https://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)
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: Longitude Index: B-Tree or Cluster

[John J Foster via 4D_Tech]

Hey Chuck,

Given my last response and my needs…

I am trying to visualize how a hash would work? Can you give me an example 
using a longitude and latitude?

Thanks,
John…

> You could use a hash and store it. I have a sequence that is too long to 
> query and that is what I did works like a charm.
> 
> Regards

**
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: Longitude Index: B-Tree or Cluster

[John J Foster via 4D_Tech]

Hi Arnaud,

Hmmm...

I think I would like the data to be obvious to my eyes when I look at it.

My initial goal was simply to be able to match up a location with a missing 
Olson Timezone ID. Import the data, fix the data in the much larger db, and 
then export it back out to reimport into it’s source db. The imported data will 
always be a much smaller subset (at this time).

Then I realized that having the ability to do a radial search would be nice.  
Show me all cities within 4 minutes from this longitude/latitude. So being able 
to search quickly is important.

So all of this work is for those two needs.

Anyway, appreciate,
John…


>> Le 13 avr. 2020 à 23:51, John J Foster via 4D_Tech <4d_tech@lists.4d.com 
>> > a écrit :
>> 
>> Hey Bernard,
>> 
>> I would use text values if I didn’t think I needed to do range searches. 
>> It’s not a “live” db so I can play and experiment to my hearts content.
> 
> Considering 5 million pairs of long/lat values is a lot, I'd first try to see 
> if I can store values in a different field type than a real. Examples:
> - integer or longint : multiply by 10^x and remove decimals; depends on the 
> number of digits you need to keep (example, Lat,Long=48.862725,2.28759 
> becomes 48862725,2287590)
> - uuid: no limit about the encoded number, but I don't know if performances 
> are better than real
> 
> -- 
> 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: Longitude Index: B-Tree or Cluster

[John J Foster via 4D_Tech]

Hi Arnaud,

I have split out the longitudes into a text and real component. I have 
formatted the longitudes as “000” and if west of GMT prefixed with “-“ and if 
east prefixed with “+“. I'll do something similar with latitudes and then try 
building some radial searches and see.

Since all string is text is there a still a way to tell 4D that a field and 
thus an index is a fixed size?

Anyway we shall see if theory and implementation matches!

Appreciate,
John…



> On Apr 14, 2020, at 12:00 PM, 4d_tech-requ...@lists.4d.com wrote:
> 
> From: Arnaud de Montard mailto:arn...@init5.fr>>
> Subject: Re: Longitude Index: B-Tree or Cluster
> Date: April 14, 2020 at 2:23:26 AM PDT
> To: 4D iNug Technical <4d_tech@lists.4d.com >
> 
> 
> 
>> Le 13 avr. 2020 à 19:36, Bernard Escaich via 4D_Tech <4d_tech@lists.4d.com 
>> > a écrit :
>> 
>> Hi John,
>> 
>> From the top of my head, indexes on long are less efficient than on text 
>> values ; I have a doubt, perhaps only for updating.
> 
> I'd think the opposite, an index based on a "fixed length" field is always 
> more efficient (search, update…) than one based on a "variable length" field. 
> 
> -- 
> 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: one server window on client

[Charles Miller via 4D_Tech]

Tried that with same result

On Tue, Apr 14, 2020 at 3:15 PM Bob Miller via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Hi Chuck,
>
> RE> A one line method
> RE> OPEN ADMINISTRATION WINDOW
>
> RE> 4D crashes every time
>
> What if you open a new process method with the one line?
>
> I call OPEN ADMINISTRATION WINDOW and it does work, but I have it in its
> own process.  Can't say why other than that's how I wrap all my primary
> methods.
>
> Bob Miller
> Parker Hannifin Corp.
> **
> 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
> **

-- 
-
 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 Server connectivity
  https://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)
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: one server window on client

[Bob Miller via 4D_Tech]

Hi Chuck,

RE> A one line method
RE> OPEN ADMINISTRATION WINDOW

RE> 4D crashes every time

What if you open a new process method with the one line?

I call OPEN ADMINISTRATION WINDOW and it does work, but I have it in its own 
process.  Can't say why other than that's how I wrap all my primary methods.

Bob Miller
Parker Hannifin Corp.
**
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
**

one server window on client

[Chuck Miller via 4D_Tech]

Hi All,

Environment windows server 2016. 4D 17.4 running as a built server. Server 
running as a service.

I am logged in as Administrator.

A one line method
OPEN ADMINISTRATION WINDOW

4D crashes every time

I have changed method to add change user crashes in the same place

Any ideas

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  

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)
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: Longitude Index: B-Tree or Cluster

[Chuck Miller via 4D_Tech]

You could use a hash and store it. I have a sequence that is too long to query 
and that is what I did works like a charm.

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  

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. 

> On Apr 14, 2020, at 5:48 AM, Arnaud de Montard via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Considering 5 million pairs of long/lat values is a lot, I'd first try to see 
> if I can store values in a different field type than a real. Examples:
> - integer or longint : multiply by 10^x and remove decimals; depends on the 
> number of digits you need to keep (example, Lat,Long=48.862725,2.28759 
> becomes 48862725,2287590)
> - uuid: no limit about the encoded number, but I don't know if performances 
> are better than real

**
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 Write Pro document to pdf?

[4dialog via 4D_Tech]

Thanks all. 
Luckily the fault was mine, not 4Ds :)

Your answers assured my that 4d can produce wp til pdffound that the
document was produced but on another disk/folder than expected...! My fault 



-
Hilsen
--
Helge Antonsen
www.4dialog.no 
--
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
**

Re: Longitude Index: B-Tree or Cluster

[Arnaud de Montard via 4D_Tech]

> Le 13 avr. 2020 à 23:51, John J Foster via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> Hey Bernard,
> 
> I would use text values if I didn’t think I needed to do range searches. It’s 
> not a “live” db so I can play and experiment to my hearts content.

Considering 5 million pairs of long/lat values is a lot, I'd first try to see 
if I can store values in a different field type than a real. Examples:
- integer or longint : multiply by 10^x and remove decimals; depends on the 
number of digits you need to keep (example, Lat,Long=48.862725,2.28759 becomes 
48862725,2287590)
- uuid: no limit about the encoded number, but I don't know if performances are 
better than real

-- 
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 Write Pro document to pdf?

[Pat Bensky via 4D_Tech]

Hilsen,
This works for me (v17r6, Mac):

*SET PRINT OPTION*(Destination option;3;$pathname)

*WP PRINT*(WPdoc)

*SHOW ON DISK*($pathname)


Pat

On Tue, 14 Apr 2020 at 10:30, 4dialog via 4D_Tech <4d_tech@lists.4d.com>
wrote:

>
> - On mac i normaly produce pdf documents via SET PRINT
> OPTION(9;3;$FileName)
> and then some print commands. But SET PRINT OPTION does not work when used
> with WP Print. No error, OK=1 but no pdf is created? Tested with 4d 16.6
> and
> 17.4.
>
> If i use SET PRINT PREVIEW(True) before WP Print, i get the WP document as
> PDF in Preview.
>
> Is it possible to print a 4d Write Pro document to a pdf file?
>
>
>
>
> -
> Hilsen
> --
> Helge Antonsen
> www.4dialog.no
> --
> 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
> **



-- 
*
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: 4d Write Pro document to pdf?

[UKVetDerm via 4D_Tech]

Hi Hilsen

This works fine for us, we never preview (16 and currently 17r6, 18 and 18r2)

$longDocName:=$pathname+$docname
SET PRINT OPTION(Orientation option;1)
SET PRINT OPTION(Destination option;3;$longDocName)
WP PRINT([Lets]LetterObject)
$newpath:=Convert path system to POSIX($longDocName)
LAUNCH EXTERNAL PROCESS("open "+Char(Double 
quote)+$newpath+(Char(Double quote)))

Hope this helps

Steve
UKVD

On 14/04/2020, 10:31, "4D_Tech on behalf of 4dialog via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:


- On mac i normaly produce pdf documents via SET PRINT OPTION(9;3;$FileName)
and then some print commands. But SET PRINT OPTION does not work when used
with WP Print. No error, OK=1 but no pdf is created? Tested with 4d 16.6 and
17.4.

If i use SET PRINT PREVIEW(True) before WP Print, i get the WP document as
PDF in Preview.

Is it possible to print a 4d Write Pro document to a pdf file?




-
Hilsen
--
Helge Antonsen
www.4dialog.no 
--
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
**

**
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 Write Pro document to pdf?

[4dialog via 4D_Tech]

- On mac i normaly produce pdf documents via SET PRINT OPTION(9;3;$FileName)
and then some print commands. But SET PRINT OPTION does not work when used
with WP Print. No error, OK=1 but no pdf is created? Tested with 4d 16.6 and
17.4.

If i use SET PRINT PREVIEW(True) before WP Print, i get the WP document as
PDF in Preview.

Is it possible to print a 4d Write Pro document to a pdf file?




-
Hilsen
--
Helge Antonsen
www.4dialog.no 
--
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
**

Re: Longitude Index: B-Tree or Cluster

[Arnaud de Montard via 4D_Tech]

> Le 13 avr. 2020 à 19:36, Bernard Escaich via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> Hi John,
> 
> From the top of my head, indexes on long are less efficient than on text 
> values ; I have a doubt, perhaps only for updating.

I'd think the opposite, an index based on a "fixed length" field is always more 
efficient (search, update…) than one based on a "variable length" field. 

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