> Le 5 déc. 2017 à 14:31, Piotr Chabot Stadhouders via 4D_Tech
> <4d_tech@lists.4d.com> a écrit :
>
> Hi Arnaud,
>
> Thanks for your thorough test.
> [...]
> In my tests I also saw this happening. Duplicating each listbox in the form
> editor with 20 columns took longer and longer.
> I didn't
Hi Tim,
Yes, I have opened a tech support case.
Gr,
Piotr
> -Oorspronkelijk bericht-
> Van: Timothy Penner [mailto:tpen...@4d.com]
> Verzonden: woensdag 6 december 2017 2:24
> Aan: 4D iNug Technical <4d_tech@lists.4d.com>
> Onderwerp: RE: poor performance
> My only hope is that 4D will investigate the command.
If you haven't already done so, please open a tech support case on taow.4d.com
or file a bug report on forums.4d.fr so that someone investigates this for you.
-Tim
**
4D
s
> Onderwerp: RE: poor performance LISTBOX INSERT COLUMN
>
> if I am correct...
> list boxes should/do behave as arrays.
>
> So... you should - no I have not done the testing - that inserting (add to
> location
> { end).
>
> EVEN IF, the array's memory did no
our list boxes I would expect this to be
slower. In a previous email I mentioned that I do dynamic list boxes
every where I use them.
I always (generic code) append the new column(s).
Listbox Insert column(listbox;size of listbox+1; colname; etc)
On Tue, 5 Dec 2017 09:11:25 +, Piotr Cha
Hi Arnaud,
Thanks for your thorough test.
>That's not surprising, IMHO, it's like concatenation: as the room is filled,
>each piece added is harder to arrange than the previous.
I understand this, but still I believe maybe there can be some performance
improvement in the command. I cannot be
> Le 5 déc. 2017 à 12:08, Arnaud de Montard via 4D_Tech <4d_tech@lists.4d.com>
> a écrit :
>
> --> 4D appreciates much better duplicate at runtime.
PS
and the .4DB file [size + complexity] too, I guess.
--
Arnaud de Montard
**
> Le 5 déc. 2017 à 10:11, Piotr Chabot Stadhouders via 4D_Tech
> <4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>> a écrit :
>
> LISTBOX INSERT COLUMN becomes slower when more columns have been inserted
That's not surprising, IMHO, it's like concatenation:
hi Alan,
Maybe calling the average was a bit misleading after all :
So I created a demo database with 1 form
On this form I have 12 listboxes with 1 column
On load of each listbox I insert 20 columns with LISTBOX INSERT COLUMN
Inspecting the 4D debug log I am seeing something I did mention
Hi Chip,
When the form is first displayed there are no elements in one of the arrays in
the listboxes
Only after certain user action, like pressing a button, the arrays are
populated, so this isn't the problem
Furthermore, I am not able to test with local 4D data because, surprise, we
don't us
th 24G memory
> When showing the listboxes for the first time the arrays have 0
> elements (after on load they are populated via 4D for OCI commands)
> Maybe it does matter how many listboxes are on the form?
> Maybe LISTBOX INSERT COLUMN becomes slower when more columns are inserted?
4D iNug Technical <4d_tech@lists.4d.com> writes:
>Maybe it does matter how many listboxes are on the form?
I assumed you built LB with one method per LB.
>
>Maybe LISTBOX INSERT COLUMN becomes slower when more columns are inserted?
I assumed that you were "appending" co
24G memory
When showing the listboxes for the first time the arrays have 0 elements (after
on load they are populated via 4D for OCI commands)
Maybe it does matter how many listboxes are on the form?
Maybe LISTBOX INSERT COLUMN becomes slower when more columns are inserted?
Miyako explained clearly
I just tested LISTBOX INSERT COLUMN command on array based LB that takes only 0
to 1 ms to complete on my MBP 2.90GHZ with 16G memory. I'm not sure if size of
array is the factor.
Alan Chan
4D iNug Technical <4d_tech@lists.4d.com> writes:
>The LISTBOX INSERT COLUMN command ta
If your customer want to be king, he/she has to act like one, spend like one.
Did your customer try to put up more resources on hardware? Investing 32G+
memory on 4.0Ghz+ machine with great grahic chip for big monitor to run your
application might be helpful especially populating 27 listbox with
thinking aloud, does it make any difference if you insert 400 empty arrays,
and then populate (copy array) the rows,
instead of inserting arrays that already contain data?
> 2017/12/03 19:08、Piotr Chabot Stadhouders via 4D_Tech <4d_tech@lists.4d.com>
> のメール:
>
> We use listboxes a lot and we real
Hi Miyako,
>I think we need to set reasonable limits on how the commands is expected to be
>used,
>before we device that its performance is "poor".
Sorry, maybe you are right and I shouldn't have called it poor performance, but
it was my feeling because the command takes 10 times longer to exec
in my view,
I think we need to set reasonable limits on how the commands is expected to be
used,
before we device that its performance is "poor".
is it really reasonable to insert 400 columns in one call?
at what point in developer did you notice the "poor performance"?
did you gradually extend
in all the development and testing when
creating this command nobody ever used it to the high level that you are and
noticed the poor performance.
>> 1. Wait for 4D to make a change to fix this (who knows if/when that would
>> happen) 2. Don’t use LISTBOX INSERT COLUMN
>
> I am goi
> Le 2 déc. 2017 à 10:10, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com> a
> écrit :
>
> Ever use:
>
> $tSQL:="SELECT * FROM "+$tTableName+" INTO : "+$tLBox
> [...]
Hi Jim,
I swear I did not copy/paste your answer :-)
Makes me think I forgot to mention that one must check 4D version befor
> Le 2 déc. 2017 à 09:38, Piotr Chabot Stadhouders via 4D_Tech
> <4d_tech@lists.4d.com> a écrit :
>
> Hi Arnaud,
>
> Array listboxes
Hi Piotr,
thanks. These users are of the air controller kind ;-)
If the performance issue is strictly related to the command that adds a new
column, i'm won
t;
> >> I have succeeded in analyzing 10 4DDebuglog.txt files (using an Oracle
> DB by the way) and have come to following :
> >> The problem is with the execution time of the "LISTBOX INSERT COLUMN"
>
> > array or selection listbox?
>
> > --
> >
I have succeeded in analyzing 10 4DDebuglog.txt files (using an Oracle DB by
>> the way) and have come to following :
>> The problem is with the execution time of the "LISTBOX INSERT COLUMN"
> array or selection listbox?
> --
> Arnaud
Hi Tim,
> -Oorspronkelijk bericht-
> Van: Tim Nevels [mailto:timnev...@mac.com]
> Verzonden: vrijdag 1 december 2017 22:00
> Aan: 4d_tech@lists.4d.com
> Onderwerp: Re: poor performance LISTBOX INSERT COLUMN
>
> On Dec 1, 2017, at 2:00 PM,Piotr Chabot Stadhouders wrot
g an Oracle DB by
> the way) and have come to following :
> The problem is with the execution time of the "LISTBOX INSERT COLUMN"
array or selection listbox?
--
Arnaud
**
4D Internet Users Group (4D iNUG)
FAQ
On Dec 1, 2017, at 2:00 PM,Piotr Chabot Stadhouders wrote:
> But, bottom line, we are skipping the fact that still the command LISTBOX
> INSERT COLUMN is very slow compared to all other commands
> And we wouldn't probably having this discussion if it was executed as fast as
> t
Piotr,
On Fri, Dec 1, 2017 at 8:59 AM, Piotr Chabot Stadhouders via 4D_Tech <
4d_tech@lists.4d.com> wrote:
> In fact our customers have big screens an want to see a lot of data at once
> They like how it is displayed right now.
> I have counted the listboxes displayed at once and the number is 10
tom line, we are skipping the fact that still the command LISTBOX
INSERT COLUMN is very slow compared to all other commands
And we wouldn't probably having this discussion if it was executed as fast as
the other commands
Again, thanks for your response,
Piotr
> -Oorspronkelij
Piotr
recode this!
On Fri, 1 Dec 2017 14:49:11 +, Piotr Chabot Stadhouders via 4D_Tech
wrote:
>
> No big deal you could say, but for a couple of our forms it IS a big deal
> We have a form with 27 listboxes on it, all dynamically build, with a
> total of 477 columns
recode this - I can't sa
Hi,
In search of a performance problem in 1 of our forms I am asking for some
advice.
I have succeeded in analyzing 10 4DDebuglog.txt files (using an Oracle DB by
the way) and have come to following :
The problem is with the execution time of the "LISTBOX INSERT COLUMN"
The performan
Cool. Thanks.
> On Jan 28, 2017, at 10:33 AM, John DeSoi wrote:
>
> Yes, you can declare a 2D array of each type and then just allocate listbox
> columns as needed from the 2D arrays.
>
> John DeSoi, Ph.D.
>
>
>
>> On Jan 28, 2017, at 12:07 PM, Lee Hinde wrote:
>>
>> In my case I am flat
> Le 28 janv. 2017 à 19:07, Lee Hinde a écrit :
>
> In my case I am flattening out c_objectc/fields. By definition I don’t know
> how many keys will be in whatever I’m finding. So I have to pre-declare my
> best guess + 10 to have them ready.
>
> I think. There isn’t a way to do this in real
Yes, you can declare a 2D array of each type and then just allocate listbox
columns as needed from the 2D arrays.
John DeSoi, Ph.D.
> On Jan 28, 2017, at 12:07 PM, Lee Hinde wrote:
>
> In my case I am flattening out c_objectc/fields. By definition I don’t know
> how many keys will be in wha
In my case I am flattening out c_objectc/fields. By definition I don’t know how
many keys will be in whatever I’m finding. So I have to pre-declare my best
guess + 10 to have them ready.
I think. There isn’t a way to do this in real time, is there?
> On Jan 28, 2017, at 8:41 AM, Arnaud de Mont
> Le 28 janv. 2017 à 00:03, Kirk Brooks a écrit :
>
> I've settled on a 3 step methodology that works like this (which I was
> tweaking just the other day):
>
> 1) get the column var pointers from the Listbox get arrays command (wrapped
> in Listbox_get_colVarArray).
> 2) declare the variable
Thank you Arnaud, that made me check and I realized that my arrays were local,
not process. Oops.
Merci.
> On Jan 27, 2017, at 3:04 PM, Arnaud de Montard wrote:
>
> Hi Lee,
> I seem to remember such an array is displayed "<>array1" in the debugger, not
> the "$array1" that one could expect.
ARRAY:
selection to array (...;$array1;...;$arrayN)
$target_p:=object get pointer (*;named object;"listbox_C1") //->listboxColumn
copy array($array1;$target_p->)
//...
$target_p:=object get pointer(*;named object;"listbox_CN")
copy array($arrayN;$target_p-&g
ll figured out years ago.
> > >
> > > For ($prop_index;1;$property_count)
> > > C_TEXT($col_name)
> > > $col_name:="$array_"+String($prop_index)
> > > $get_pointer:=Get pointer($col_name)
> > >
> > > $col_hea
gt; $get_pointer:=Get pointer($col_name)
> >
> > $col_header_name:="$header_text_"+String($prop_index)
> > $get_header_ptr:=Get pointer($col_header_name)
> >
> > LISTBOX INSERT COLUMN(*;$list_box_name;$prop_
> index;$col_name;$get_
col_name)
>
> $col_header_name:="$header_text_"+String($prop_index)
> $get_header_ptr:=Get pointer($col_header_name)
>
> LISTBOX INSERT
> COLUMN(*;$list_box_name;$prop_index;$col_name;$get_pointer->;$col_header_name;$get_header_ptr->)
> OBJE
ter($col_header_name)
LISTBOX INSERT
COLUMN(*;$list_box_name;$prop_index;$col_name;$get_pointer->;$col_header_name;$get_header_ptr->)
OBJECT SET TITLE($get_header_ptr->;$lb_property_names{$prop_index})
End for
$count:=LISTBOX Get number of columns(*;$list_box_name)
LISTBOX
Ahh
Drag the headers - Excellent
Thanks very much
cheers
-pm
On Fri, Oct 7, 2016 at 9:16 PM, Keith Culotta wrote:
> I forget how v13 may have accomplished this... In v15 the contextual menu
> has "Add column before", "Add column after" options. You should also be
> able to grab the Header cell
I forget how v13 may have accomplished this... In v15 the contextual menu has
"Add column before", "Add column after" options. You should also be able to
grab the Header cell of the column and drag it left and right.
Keith - CDI
> On Oct 7, 2016, at 3:08 PM, Peter Mew wrote:
>
> Nope
> If I
Nope
If I do that the column is added at the right hand side, then how do I move
it between existing columns 2 & 3.
And how do I delete a column?
this is v13 and Yosemite
thanks
-pm
On Fri, Oct 7, 2016 at 8:47 PM, Keith Culotta wrote:
> Highlight a column. Right-click (or control-click) on the
Highlight a column. Right-click (or control-click) on the column and you will
see the contextual menu.
Keith - CDI
> On Oct 7, 2016, at 2:32 PM, Peter Mew wrote:
>
> Hi
> I cant find how to do this.
> I have an array based listbox, with several columns.
> I now want to add another column betw
Hi
I cant find how to do this.
I have an array based listbox, with several columns.
I now want to add another column between my existing column 2 and column 3
not by code, but in the design environment
Ive tried adding a new column at the right hand end and dragging it, I cant
find an insert column
46 matches
Mail list logo