Re: Modal dialog dilemma

2017-06-28 Thread Robert ListMail via 4D_Tech
Wow Jody—impressive! So, when does your new shell go on sale? :) Robert Sent from my iPhone > On Jun 19, 2017, at 11:08 AM, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Every line of code is being rewritten in a clean room concept. We want to > encourage ourselves to write all

Re: Optimizing and improving 4D queries.

2017-06-28 Thread John DeSoi via 4D_Tech
No, this is set as b-tree (automatic). I think that is best setting for this field, but worth checking into to see if it might help. John DeSoi, Ph.D. > On Jun 28, 2017, at 9:00 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > do you have cluster b-tree indexes for that fiel

Re: Optimizing and improving 4D queries.

2017-06-28 Thread Eric Naujock via 4D_Tech
The field is indexed with btree since its designed for lots of unique values and its a UUID. This was based on the technote regarding the optimal index to use. --- MacCafe 4405 Talmadge St. Toledo, OH 43623 Eric Naujock - AC

Re: Optimizing and improving 4D queries.

2017-06-28 Thread Keisuke Miyako via 4D_Tech
do you have cluster b-tree indexes for that field? > 2017/06/29 9:55、John DeSoi via 4D_Tech <4d_tech@lists.4d.com> のメール: > > 4D reports the table is not fragmented. I have not tried compacting or > rebuilding indexes yet. You might give this a try to see if it makes a > difference. *

Re: Optimizing and improving 4D queries.

2017-06-28 Thread Eric Naujock via 4D_Tech
My biggest table tends to only have around 40K records. This is the main table that most supporting tables revolve around. I did a compact on the database earlier in the day (This is my dev database) so there should be almost on fragmentation. The relate many is run on the table primary key wh

Re: Error -19191

2017-06-28 Thread Keisuke Miyako via 4D_Tech
auto upgrading to a different major version is only available in v13->v14 or later. see http://kb.4d.com/assetid=76989 also http://doc.4d.com/4Dv16/4D/16/Overview.300-3130240.en.html > 2017/06/29 10:45、Costas Manousakis via 4D_Tech <4d_tech@lists.4d.com> のメール: > We’ve seen this error when a v

Re: Error -19191

2017-06-28 Thread Costas Manousakis via 4D_Tech
We’ve seen this error when a v11 built client tries to connect to a v15 built server. The v15 server is not set to autoupdate clients. Regards, Costas > On Jun 27, 2017, at 9:15 AM, Douglas Cryer via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi, > > We have a client trying to connect to a d

Re: Optimizing and improving 4D queries.

2017-06-28 Thread John DeSoi via 4D_Tech
Do any of the tables have a large number records? I have noticed recently that large tables (e.g. 20 million records) are very slow with DISTINCT VALUES even on indexed fields with a relatively small number values. For example on a big table and selection of 14,000 records DISTINCT VALUES only t

Re: Optimizing and improving 4D queries.

2017-06-28 Thread Guy Algot via 4D_Tech
Eric, How long does a query on the related field take? Any picture or blob fields in the related table? Those could slow down the loading of the related records. > On Jun 28, 2017, at 5:59 PM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I have been trying to do some performanc

Optimizing and improving 4D queries.

2017-06-28 Thread Eric Naujock via 4D_Tech
I have been trying to do some performance tuning an optimizing on one of my 4D databases and am finding that one function RELATE MANY is taking over 1790 ms. At lease are there any 4d Tools that are available to help analyze the case of tis timeout and resolve the issue. I have tried adjusting t

Re: Automatic type-ahead on single-column listbox?

2017-06-28 Thread David Adams via 4D_Tech
> Is that actually type-ahead or simply setting the scroll on the edited text with a wildcard? Don't know...but it's just what I need for my simple uses. It would be nice to have it in listboxes, but I guess that would take having a mechanism for identifying with column has focus. Although in the

Re: Automatic type-ahead on single-column listbox?

2017-06-28 Thread Kirk Brooks via 4D_Tech
David, Oh, that. Makes me realize how fast you must type to get more than a couple of letters deep. Not really great for lists with a few thousand rows I don't think. Is that actually type-ahead or simply setting the scroll on the edited text with a wildcard? On Wed, Jun 28, 2017 at 5:53 AM, Dav

Re: Rotate Picture in 4D

2017-06-28 Thread Peter Mew via 4D_Tech
Hi Now I have got to grips with it, The fastest rotate Image Function seems to be the "4d-plugin-imagemagick-master", about 10% faster than LEP and Imagemagick. Also, easier for cross platform deployment v13.6 cheers -pm On Tue, Jun 27, 2017 at 12:22 PM, Keisuke Miyako via 4D_Tech < 4d_tech@lists

Re: Automatic type-ahead on single-column listbox?

2017-06-28 Thread David Adams via 4D_Tech
> They do? ​Remind me how that works. I don't think I ever knew that. They work great! Set up an hlist and populate it. Sort of a one-column listbox without all of the glitter. Give the area focus and start typing. You automatically move to the right item. Handy for navigating something like a lis

Re: Automatic type-ahead on single-column listbox?

2017-06-28 Thread Kirk Brooks via 4D_Tech
David, On Wed, Jun 28, 2017 at 3:04 AM, David Adams via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > It does if it’s only a single column. You don’t use a listbox, you use a > hierarchical list. > > ​... > Hlists don't have all of the nice style > ​ ​ > features of a listbox, but they do have built

Re: Automatic type-ahead on single-column listbox?

2017-06-28 Thread Jeffrey Kain via 4D_Tech
4D's search widget works pretty well as a type-ahead alternative, and it's very easy to integrate with any listbox. > On Jun 28, 2017, at 6:04 AM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I primarily use 4D to crunch up stuff and spit it out for other programs to > consume, n

Re: Automatic type-ahead on single-column listbox?

2017-06-28 Thread David Adams via 4D_Tech
> It does if it’s only a single column. You don’t use a listbox, you use a hierarchical list. That's what I was remembering! Hlists don't have all of the nice style features of a listbox, but they do have built-in type ahead, thanks. > If it’s more than one column then ditch the listbox and use D