Scrolling speed of a data grid

[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 <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