Re: AW: Re: I need some DataGrid performance help

2020-05-07 Thread Curry Kenworthy via use-livecode
(I know that Paul understands tradeoffs very well, so he already knows this, but for the benefit of others) Maybe some concepts are so simple, people never take them seriously: - You reap what you sow. You get the cake you bake. - Comparisons: 1 < 2 - Complexity often reduces efficienc

AW: Re: I need some DataGrid performance help

2020-05-07 Thread Paul Dupuis via use-livecode
Reduced to a consistent 1.5 to 2 minutes by revising the setting of datagrid column properties the columns themselves, widths, and alignments set all at one. Tooltips, sort type and sort direction set in a loop in revised code. I still do not understand why in the original code, when 1st set

Re: I need some DataGrid performance help

2020-05-06 Thread Richard Gaskin via use-livecode
Mark Waddingham wrote: On 2020-05-06 17:36, Richard Gaskin via use-livecode wrote: A while back Mark Waddingham reviewed the situation and decided that getProp and setProp were indeed more rightly in the category of custom messages rather than system messages, and as such should ideally be immu

Re: I need some DataGrid performance help

2020-05-06 Thread Paul Dupuis via use-livecode
On 5/6/2020 1:53 PM, Mark Waddingham via use-livecode wrote: In reality, 'lock messages' is a sledge-hammer and like a sledge-hammer it can cause fallout if not wielded carefully. Slightly off topic, but I have run into time where I wish I could lock a specific message or set of messages. So

Re: I need some DataGrid performance help

2020-05-06 Thread Mark Waddingham via use-livecode
On 2020-05-06 17:36, Richard Gaskin via use-livecode wrote: A while back Mark Waddingham reviewed the situation and decided that getProp and setProp were indeed more rightly in the category of custom messages rather than system messages, and as such should ideally be immune to the effects of "loc

Re: I need some DataGrid performance help

2020-05-06 Thread Mark Wieder via use-livecode
On 5/6/20 5:35 AM, Paul Dupuis via use-livecode wrote: This code is called only when the data is changed such as columns added or removed or rows added or removed or both. What I do is set the data initially, then cache the existing setup in a local array. When something changes I can examine

Re: I need some DataGrid performance help

2020-05-06 Thread Richard Gaskin via use-livecode
zryip theSlug wrote: > datagrids are using virtual properties, so you can't lock the > messages. Reminds me: we have a request to do away with that,since it complicates a lot of otherwise-powerful-and-simple things we can do with custom controls. A while back Mark Waddingham reviewed the sit

Re: I need some DataGrid performance help

2020-05-06 Thread zryip theSlug via use-livecode
Paul, datagrids are using virtual properties, so you can't lock the messages. tooltip, sorttype, and editability have only an effect if one interact with the datagrid. I do not think this is your issue. Plus, I ran in a similar problem when I updated DGH 2.5 with column color capabilities. One of

Re: I need some DataGrid performance help

2020-05-06 Thread Paul Dupuis via use-livecode
On 5/6/2020 7:58 AM, zryip theSlug via use-livecode wrote: After each call to a column property such as dgColumnWidth, the datagrid is resized (header, column, rectangles, etc) This I did not know. Thank you. Instead of having them in the loop, prepare the column size, columns label, etc and

Re: I need some DataGrid performance help

2020-05-06 Thread Paul Dupuis via use-livecode
On 5/6/2020 6:55 AM, Pi Digital via use-livecode wrote: What handler do you have this code? From what you are saying it seems it’s deploying this formatting script every time it redraws which itself is very inefficient and unnecessary. It should only have to deal with the data itself ideally.

Re: I need some DataGrid performance help

2020-05-06 Thread zryip theSlug via use-livecode
Paul, After each call to a column property such as dgColumnWidth, the datagrid is resized (header, column, rectangles, etc) Instead of having them in the loop, prepare the column size, columns label, etc and uses the table properties existing for setting all the values at once. In this case the r

Re: I need some DataGrid performance help

2020-05-06 Thread Pi Digital via use-livecode
Hi Paul What handler do you have this code? From what you are saying it seems it’s deploying this formatting script every time it redraws which itself is very inefficient and unnecessary. It should only have to deal with the data itself ideally. Sean Cole Pi Digital Productions Ltd eMail Ts

Re: I need some DataGrid performance help

2020-05-05 Thread Paul Hibbert via use-livecode
I’ve no idea if this could help or even if this may cause worse problems with a DG, so just a thought, but have you tested with Lock Screen, Lock Messages and/or Lock Updates while the repeat is processing? Failing that, I would try disabling each command in turn to find out if just one of them

I need some DataGrid performance help

2020-05-05 Thread Paul Dupuis via use-livecode
I have a datagid operation that should be fast that is taking a long time and I don't understand why. I use a datagrid to display a table of data as part of an analysis. The columns are file names and the rows are selected phrases found in those files. The first column is the list of phrases (