Re: [gnome-db] execute raw sqlite statements
Vivien Malerba <[email protected]>
| Newsgroups | gmane.comp.gnome.db |
|---|---|
| Message-ID | <[email protected]> |
On 2 June 2010 23:47, Massimo Cora' <[email protected]> wrote: > Hi, > > On 06/01/2010 07:46 PM, Vivien Malerba wrote: >> >> For your information, I've just checked in a modification which, if >> the GDA_CONNECTION_OPTIONS_THREAD_SAFE flags is specified, will not >> automatically execute a sub thread (if the "normal" connection already >> supports multi thread access). >> >> As SQLite is normally already thread safe, you will have performances >> increases if you use the GDA_CONNECTION_OPTIONS_THREAD_SAFE flag. >> > > yeah, you're right. My transaction now drops from 2.99 to 1.8, gaining 1 > second! > thanks a lot. I think now I'm satisfied with the performance. Good, I'll see if I can improve things more. Another idea: you could use a GdaThreadWrapper object to execute all the INSERTs in another thread wo you don't have to wait, see http://library.gnome.org/devel/libgda/4.1/GdaThreadWrapper.html. Vivien