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.heaf...@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 <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 _______________________________________________ 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
