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 _______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
