SQL lite adding records

JB sundown at pacifier.com
Tue Mar 24 23:36:35 EDT 2015


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 <dochawk at gmail.com> wrote:

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





More information about the Use-livecode mailing list