On Tue, Feb 17, 2015 at 2:20 PM, Mike Kerner <mikeker...@roadrunner.com> wrote:
> I didn't include everything, including the transaction code, or opening the > database in memory instead of on a disk. When we were messing with this, > the piece that became the (58 minute) bottleneck was inside the loop, or, > according to Peter, the way the chunks are accessed in the loop. > Yes--but a large number of db accesses have their own time cost. If you can combine many to one, there is a *huge* savings to be had. -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 _______________________________________________ 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