You are not logged in.
Pages: 1
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!
Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.
Offline
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
Offline
Wow! The batch update mode is great!
Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.
Offline
Pages: 1