Re: poor performance LISTBOX INSERT COLUMN

> 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

RE: poor performance LISTBOX INSERT COLUMN

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

RE: poor performance LISTBOX INSERT COLUMN

> 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

RE: poor performance LISTBOX INSERT COLUMN

p.stadhoud...@timeff.com> > 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'

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 { 11, 11-> 12 etc). This will/does/should add overhead. If you are inserting - especially blank/empty columns - rather then appending the columns to your

RE: poor performance LISTBOX INSERT COLUMN

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

Re: poor performance LISTBOX INSERT COLUMN

> 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

Re: poor performance LISTBOX INSERT COLUMN

> Le 5 déc. 2017 à 10:11, Piotr Chabot Stadhouders via 4D_Tech > <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: as the room is filled, each piece

RE: poor performance LISTBOX INSERT COLUMN

in front others? Gr, Piotr > -Oorspronkelijk bericht- > Van: Alan Chan [mailto:a...@belhk.com] > Verzonden: maandag 4 december 2017 9:46 > Aan: 4d_tech@lists.4d.com > Onderwerp: Re: poor performance LISTBOX INSERT COLUMN > > 4D iNug Technical <4d_tech@lists.4d.c

RE: poor performance LISTBOX INSERT COLUMN

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

RE: poor performance LISTBOX INSERT COLUMN

Piotr, maybe it is the remote data call/population of the listbox arrays? for comparison try: - populate the listbox from local (4D) data On Mon, 4 Dec 2017 07:59:00 +, Piotr Chabot Stadhouders via 4D_Tech wrote: > > I tested this on an HP Intel Core i7-4710MQ 2.50GHz laptop with 24G

Re: poor performance LISTBOX INSERT COLUMN

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" column instead of inserting

RE: poor performance LISTBOX INSERT COLUMN

Hi Alan, Thanks for testing! This is great news, because then maybe there is something else going on. Remember, I only asked the community if this performance was normal behavior and if it could be confirmed. Clearly not by you. I tested this on an HP Intel Core i7-4710MQ 2.50GHz laptop with

Re: poor performance LISTBOX INSERT COLUMN

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 takes on average

Re: poor performance LISTBOX INSERT COLUMN

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

Re: poor performance LISTBOX INSERT COLUMN

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

RE: poor performance LISTBOX INSERT COLUMN

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

Re: poor performance LISTBOX INSERT COLUMN

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

Re: poor performance LISTBOX INSERT COLUMN

On Dec 2, 2017, at 2:00 PM,Piotr Chabot Stadhouders wrote: >> There is an old saying where a man goes to the doctor and says “when I move >> my arm like this it hurts, can you fix this” and the doctor replies “yes, >> don’t >> move your arm like that”. :) > > One could also say : "A man goes to

Re: poor performance LISTBOX INSERT COLUMN

> 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

Re: poor performance LISTBOX INSERT COLUMN

> 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

Re: poor performance LISTBOX INSERT COLUMN

Ever use: $tSQL:="SELECT * FROM "+$tTableName+" INTO : "+$tLBox to create a listbox with all fields as columns and then hide the unwanted columns? On Sat, Dec 2, 2017 at 9:38 AM, Piotr Chabot Stadhouders via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Arnaud, > > Array listboxes > > >> Le 1

RE: poor performance LISTBOX INSERT COLUMN

Hi Arnaud, Array listboxes >> Le 1 déc. 2017 à 15:49, Piotr Chabot Stadhouders via 4D_Tech >> <4d_t...@xxx.xxx> a écrit : >> >> 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

RE: poor performance LISTBOX INSERT COLUMN

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

Re: poor performance LISTBOX INSERT COLUMN

> Le 1 déc. 2017 à 15:49, Piotr Chabot Stadhouders via 4D_Tech > <4d_tech@lists.4d.com> a écrit : > > 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

Re: poor performance LISTBOX INSERT COLUMN

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 > the other commands

Re: poor performance LISTBOX INSERT COLUMN

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

RE: poor performance LISTBOX INSERT COLUMN

icht- > Van: Chip Scheide [mailto:4d_o...@pghrepository.org] > Verzonden: vrijdag 1 december 2017 16:35 > Aan: 4D iNug Technical <4d_tech@lists.4d.com> > CC: Piotr Chabot Stadhouders <p.stadhoud...@timeff.com> > Onderwerp: Re: poor performance LISTBOX INSERT COLUMN > &

Re: poor performance LISTBOX INSERT COLUMN

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

poor performance LISTBOX INSERT COLUMN

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 performance of this