Re: [gnome-db] execute raw sqlite statements

[Vivien Malerba <vmalerba gmail com>]

On 2 June 2010 23:47, Massimo Cora' <maxcvs email it> 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