bulk inserts via Synopse SQLITE Framework

edwinsn · 2011-03-27 08:05:33

Hi Arnaud,

With my planned program, the server will mostly receive new objects (IOW, insert commands) from multiple clients. In my previous experience with sqlite, wrapping a bunch of insert commands with 'BEGIN TRANS...' and 'COMMIT TRANS...' Can speed things up a lot. How we do this in Synopse sqlite?

And other tips you can give me to speed up such bulk insert operations?

Thanks!

ab · 2011-03-27 08:08:56

You have TSQLRest.TransactionBegin and TSQLRest.Commit/RollBack methods for creating a transaction.

On a slow network, you could also use a Batch process to speed up the communication.
See http://synopse.info/forum/viewtopic.php?id=250

edwinsn · 2011-03-27 10:22:44

Wow! The batch update mode is great!

mORMot Open Source

#1 2011-03-27 08:05:33

bulk inserts via Synopse SQLITE Framework

#2 2011-03-27 08:08:56

Re: bulk inserts via Synopse SQLITE Framework

#3 2011-03-27 10:22:44

Re: bulk inserts via Synopse SQLITE Framework

Board footer