We both used in memory databases. The filename is ";memory:" On Fri Feb 13 2015 at 2:46:45 PM Bob Sneidar <bobsnei...@iotecdigital.com> wrote:
> He may also have been using a memory resident database. That is what I > suggested at the first. To do this, use “memory” as the file name. > > Bob S > > > On Feb 13, 2015, at 12:40 , Mike Kerner <mikeker...@roadrunner.com<mailto: > mikeker...@roadrunner.com>> wrote: > > I must have missed a thread, somewhere. That would be the thread on how LC > handles loops. > > To recap, doing this sort using an sqlite database (insert the values into > a table, then sort the table), was taking me almost 40 seconds. Then Pete > chimed in and had it working in a couple hundred milliseconds. > > The difference? Pete was using a loop of the form > repeat for each line tLine in theData > > and I was doing a > repeat with i = 1 to the number of lines in tData > > > So, is there some more in-depth discussion of loop forms in LC, somewhere? > I learned something new, today, because 300x faster is a little bit > important. > > _______________________________________________ > 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
