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 <[email protected]> wrote: > On Tue, Mar 24, 2015 at 8:19 PM, JB <[email protected]> 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 > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
