It is a disk stored db, and I will be adding a lot of records at one time every so often. Speeding it up will be great!
thanks again, John Balgenorth On Mar 24, 2015, at 8:30 PM, Dr. Hawkins <doch...@gmail.com> wrote: > On Tue, Mar 24, 2015 at 8:19 PM, JB <sund...@pacifier.com> wrote: > >> I have not heard of BEGIN TRANSACTION >> but I will give it a try. >> > > At least assuming a disk stored db, it is likely also faster. > > In my case, I pull several hundred records from a remote postgres db, and > stash them into a memory sqlite db. > > My enemy isn't local performance, but lag on each transaction; combining > tehm makes my application possible. > > > -- > 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 > _______________________________________________ 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
