> Le 5 déc. 2017 à 10:11, Piotr Chabot Stadhouders via 4D_Tech > <[email protected] <mailto:[email protected]>> 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 added is harder to arrange than the previous. You should try a form with one "template" listbox having columns in excess, then on runtime [duplicate listbox / fill with data / remove useless columns], as much times as you need. Based on these tests: 1/ template listbox has one column, I duplicate it 12 times and use LISTBOX INSERT COLUMN to each duplicate this is what happens when the final number of colums grows (20, 40 ,60, etc.) <https://screencast.com/t/m6LPFFWcFCu1 <https://screencast.com/t/m6LPFFWcFCu1>> --> time to create columns is exponential… 2/ template listbox has 100 columns 2a/ duplicate it 12 times so we have 12 LB of 100 columns each at end 345 ms (reference time) 2b/ duplicate it 12 times, and delete 80 columns in each clone 342 ms --> time to delete columns is negligible 3/ I wanted to try with pre existing 12 listboxes of 100 columns in the form (intead of duplicating a template one at runtime). So I began in the form editor: select listbox, ctrl+D, ctrl+D, ctrl+D… 😱😱😱 each ctrl+D displays the wheel of death, each time longer than the previous. I could never bear such waiting time! --> 4D appreciates much better duplicate at runtime. -- Arnaud de Montard ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
