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 <p...@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
