Scrolling speed of a data grid

[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 average 10,000 records a day.

> On Feb 25, 2014, at 5:04 PM, Terence Heaford <t.heaford at btinternet.com> wrote:
> 
> 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 <pete at lcsql.com> wrote:
>> 
>> I assume you get the SQLite data with 1 SELECT statement then load it all
>> into the datagrid?  What method are you using to load it into the datagrid,
>> dgText or dgData?  Neither one should cause the timing you're seeing but
>> might give a clue as to what's happening.
>> 
>> There is an alternative way to load large amounts of data into a datagrid
>> by using the dgNumberOfRecords property but it's considerably more
>> complicated than using dgData or dgText and really shouldn't be needed for
>> 1700 records.
>> 
>> Pete
>> lcSQL Software <http://www.lcsql.com>
>> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
>> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode