Re: Scrolling speed of a data grid

2014-02-28 Thread Terence Heaford
Must have messed up somewhere. repeatRate Seems OK now. The speed is still sluggish though irrespective of the setting. All the best Terry On 27 Feb 2014, at 21:27, Kay C Lan wrote: > > New stack, new btn: > > on mouseUp > set the repeatRate to 20 > end mouseUp > > Press the btn and

Re: Scrolling speed of a data grid

2014-02-27 Thread Kay C Lan
On Thu, Feb 27, 2014 at 11:01 PM, Terence Heaford wrote: > > This assumes of course it is reset each time you close LC. > > That's what happens on my machine: OS X 10.9.2, LC 6.5.2 New stack, new btn: on mouseUp set the repeatRate to 20 end mouseUp Press the btn and in the msg box 'put the r

Re: Scrolling speed of a data grid

2014-02-27 Thread Terence Heaford
Out of interest when I close down LiveCode and reopen it and in the message box type put the repeatRate, it always comes back at 1 not 50. Either the Language Guide is wrong and it is reset to 1 and not 50 or the default setting has been changed to 1 and not 50 and the Language Guide is incorrec

Re: Scrolling speed of a data grid

2014-02-27 Thread Trevor DeVore
On Wed, Feb 26, 2014 at 5:05 PM, Terence Heaford wrote: > repeatRate is clearly working because if i raise it significantly > everything slows to a crawl but honestly > I can't notice much difference between 50 and 10 or 0 with my 1700 > records. > > Perhaps it's time to give this one up and put

Re: Scrolling speed of a data grid

2014-02-26 Thread Terence Heaford
repeatRate is clearly working because if i raise it significantly everything slows to a crawl but honestly I can't notice much difference between 50 and 10 or 0 with my 1700 records. Perhaps it’s time to give this one up and put up with it, unless you have any other ideas. Thanks Terry On

Re: Scrolling speed of a data grid

2014-02-26 Thread Trevor DeVore
On Wed, Feb 26, 2014 at 3:45 PM, Terence Heaford wrote: > Tried it, no difference. > > set the repeatRate to 10 > > in the openCard handler with no effect > > changed it to 0 with no effect. > > Is there a particular place to use this? > It is a global property. I just set it via the message box.

Re: Scrolling speed of a data grid

2014-02-26 Thread Terence Heaford
Tried it, no difference. set the repeatRate to 10 in the openCard handler with no effect changed it to 0 with no effect. Is there a particular place to use this? All the best Terry On 26 Feb 2014, at 20:32, Trevor DeVore wrote: > Try setting the repeatRate to 10. This should speed up the s

Re: Scrolling speed of a data grid

2014-02-26 Thread Trevor DeVore
On Wed, Feb 26, 2014 at 3:02 PM, Terence Heaford wrote: > > Thanks for the script. > > Tried it a few times, average 5420 > > So, it seems it's the scrollbarDrag message? > > I don't suppose there's much that can be done then without RunRev input? > Try setting the repeatRate to 10. This should s

Re: Scrolling speed of a data grid

2014-02-26 Thread Terence Heaford
Hi Trevor, Thanks for the script. Tried it a few times, average 5420 So, it seems it’s the scrollbarDrag message? I don’t suppose there’s much that can be done then without RunRev input? I am on a Mac, I wonder if the update to Cocoa will sort it out? I am not really sure what is happening wh

Re: Scrolling speed of a data grid

2014-02-26 Thread Trevor DeVore
On Wed, Feb 26, 2014 at 5:02 AM, Terence Heaford wrote: > > It can be seen that the simple table has better performance than the Data > Grid probably because it has no > bells and whistles. > Could this be why I am getting a performance hit from the Data Grid? > > I hope there is a solution. > Te

Re: Scrolling speed of a data grid

2014-02-26 Thread Peter Haworth
Hi Terence, You're right, modTableField doesn't have a built-in way to right justify a column. I hope one day LC implements right (and center) tabs. I did come up with a workaround to right justify a column which seems to work speedily. If you're interested email me off list and I'll send it to

Re: Scrolling speed of a data grid

2014-02-26 Thread Terence Heaford
Hi, I have looked at modTableField but noted in the docs you can’t have right alignment unless I misread that would mean no decimal point alignment. All the best Terry On 26 Feb 2014, at 17:23, Peter Haworth wrote: > > If you're looking for a ready-to-use table control, I will, once again,

Re: Scrolling speed of a data grid

2014-02-26 Thread Peter Haworth
Hi Terry, I watched both videos, also played them side-by-side for comparison. I do see a slight difference but I'm sure it's mostly due to the complexity of the datagrid caused by its extra functionality over your table, even though you're not using the extras. Sounds like Trevor may have some t

Re: Scrolling speed of a data grid

2014-02-26 Thread Terence Heaford
Hi Trevor, As promised I have made two short videos and uploaded them to dropbox. Here are the links: https://db.tt/N5uFSHft https://db.tt/Em7cHRsS Both zip files are approx. 25mb. The first link is to a video of the Data Grid and demonstrates it’s action. The second link is to a Table consi

Re: Scrolling speed of a data grid

2014-02-25 Thread Colin Holgate
In a sense it doesn’t matter if it is smooth enough. If the test was to click and hold on scroll bar to page downwards, that should be a fair test across tools. If LiveCode is managing 9 updates per second, and the others are managing 15 per second, they are presumably faster at that task. I wo

Re: Scrolling speed of a data grid

2014-02-25 Thread Terence Heaford
Hi, Times getting on here in the UK.(22:11), it’s getting time for bed for old people like me. I will fabricate some not sensitive data for the table and create a quicktime movie and post it where you can see it. Will do this tomorrow. Thanks for taking the time to think about this. All the

Re: Scrolling speed of a data grid

2014-02-25 Thread PystCat
Would it speed things up by using the dgData command instead...? Its an array... Again... Grasping at straws here... I've never seen a datagrid misbehave like you've described... My apps use a LOT of datagrids and my tables are 100's of thousands of records... I have one table that adds on aver

Re: Scrolling speed of a data grid

2014-02-25 Thread Terence Heaford
My mistake, when I said fixed row height I meant all rows have the same height of 25. The text is Lucida Grande 13 point. All the best Terry On 25 Feb 2014, at 20:20, zryip theSlug wrote: > Terry, > > "Fixed row height" is an option only available for datagrid forms, so > it should be on no

Re: Scrolling speed of a data grid

2014-02-25 Thread Terence Heaford
Hi, Correct. one sqlite then dgText. I have used the other (large data set) method in a previous attempt to improve performance but basically with the same result. All the best Terry On 25 Feb 2014, at 20:17, Peter Haworth wrote: > I assume you get the SQLite data with 1 SELECT statement th

Re: Scrolling speed of a data grid

2014-02-25 Thread Trevor DeVore
On Tue, Feb 25, 2014 at 2:09 PM, Terence Heaford wrote: > Out of interest > > LiveCode. > > 1. Scrolling with Page Up/Down keys 7.5 seconds > 2. Scrolling with Page Up/Down via mouse 9 seconds. Hi Terence, This sounds more of a speed issue related to how often the scrolling is fired while using

Re: Scrolling speed of a data grid

2014-02-25 Thread zryip theSlug
Terry, "Fixed row height" is an option only available for datagrid forms, so it should be on no help here. For datagrids working with databases, you should have a look to this lesson: http://lessons.runrev.com/s/lessons/m/datagrid/l/7341-displaying-large-amounts-of-data Basically the trick is to

Re: Scrolling speed of a data grid

2014-02-25 Thread Peter Haworth
On Tue, Feb 25, 2014 at 11:24 AM, Terence Heaford wrote: > As for passing the data in, it is simply tab/return delimited from the > Sqlite database > which I believe the DataGrid converts to an array for internal use storing > at as > > [row]["date"] > [row]["type"] > etc.. > I assume you get the

Re: Scrolling speed of a data grid

2014-02-25 Thread Richard Gaskin
Terence Heaford wrote: > Fixed height row is being used. > > As for passing the data in, it is simply tab/return delimited from > the Sqlite database which I believe the DataGrid converts to an array > for internal use storing at as > > [row][“date”] > [row][“type”] > etc.. > > There are 3 behavi

Re: Scrolling speed of a data grid

2014-02-25 Thread Terence Heaford
Richard, Fixed height row is being used. As for passing the data in, it is simply tab/return delimited from the Sqlite database which I believe the DataGrid converts to an array for internal use storing at as [row][“date”] [row][“type”] etc.. There are 3 behaviour scripts, for date, amount,

Re: Scrolling speed of a data grid

2014-02-25 Thread Colin Holgate
Yes, that was what I was thinking. I see you’re getting 9 per second with the mouse. On Feb 25, 2014, at 2:03 PM, Terence Heaford wrote: > I may have confused you by referring to page Up/Down, I actually meant the > pageUp/Down parts of the scrollbar.

Re: Scrolling speed of a data grid

2014-02-25 Thread Terence Heaford
Out of interest LiveCode. 1. Scrolling with Page Up/Down keys 7.5 seconds 2. Scrolling with Page Up/Down via mouse 9 seconds. All the best Terry On 25 Feb 2014, at 18:57, Colin Holgate wrote: > Would you be able to post your simple test stack? It’s quite possible that > LiveCode ends up be

Re: Scrolling speed of a data grid

2014-02-25 Thread Richard Gaskin
Terence Heaford wrote: ... > I then saw LiveCode and placed a small contribution to the > update/stretch goals as I was/am concerned that SC is not going to > be updated. FWIW, SC's lead developer, Mark Lucas, is a friend of mine, and I'm in touch with him pretty regularly. We'd talk more ofte

Re: Scrolling speed of a data grid

2014-02-25 Thread Terence Heaford
I am a little confused by your suggestion. All scrolling of the LC DataGrid is done by holding the mouse down in the DataGrid scrollbar and not via. the keyboard. I may have confused you by referring to page Up/Down, I actually meant the pageUp/Down parts of the scrollbar. All the best Terry

Re: Scrolling speed of a data grid

2014-02-25 Thread Colin Holgate
Would you be able to post your simple test stack? It’s quite possible that LiveCode ends up being slower, but one possibility is that in the other two cases the scrolling is happening if the key is pressed at the time, and in LiveCode it may be limited by the keyboard repeat rate. So, it would b

Scrolling speed of a data grid

2014-02-25 Thread Terence Heaford
New thread created following Richards comment in Support for Mac OSX 10.5 > The main reason I have not become a fully paid up member is for me > the lack of a speedy scrolling data grid. > Do you have any details on that you can share? Between Trevor's excellent > scripting, recent additions t