SQL lite adding records
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!
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:
More information about the Use-livecode