Thanks for your reply Pavel.....I hope that the provided example has some sense 
for sqlite but with the version used and from the java layer I was not able to 
grab connections with such config...removing the journal mode off in my code 
and i get an usable connection ....
Regards
Jerome
---- Envoyé avec BlackBerry® d'Orange ----

-----Original Message-----
From: Pavel Ivanov <paiva...@gmail.com>
Sender: sqlite-users-boun...@sqlite.org
Date: Fri, 2 Sep 2011 10:42:06 
To: General Discussion of SQLite Database<sqlite-users@sqlite.org>
Reply-To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Subject: Re: [sqlite] Fine tuning of Sqlite

>> Do you set of PRGAMAS uncompatible ? e;g:
>> setting synchronous=true + journal_mode=off is a non sense for sqlite
>> so engine can't deliver connections
>
> I think I now see what you want: a table saying if you have PRAGMA A set to 
> THIS, then PRAGMA B has no effect.

Personally I don't know of any incompatible pragmas. And concerning
the given example synchronous=true and journal_mode=off is not a
nonsense for SQLite. It will happily work exactly as you asked -
without journal and using fsyncs. It may be or may be not a nonsense
from the application point of view, or it's better to say application
can easily break with such settings in certain situations. But it
depends on the application and for some of them it could be pretty
acceptable.


Pavel


On Fri, Sep 2, 2011 at 8:26 AM, Simon Slavin <slav...@bigfraud.org> wrote:
>
> On 2 Sep 2011, at 8:08am, jerome moliere wrote:
>
>> I want to setup a benchmark injecting different configurations of the
>> sqlite engine and doing different queries (insert/select ) into
>> different transactional contexts over dummy data......
>> For such job I need to inject different PRAGMAs isn't it ?
>> Setting up :
>> synchronous , read_uncommitted, and so on
>
> I'm sorry but I can't help with this.  I hope someone else reading this can.
>
>> Do you set of PRGAMAS uncompatible ? e;g:
>> setting synchronous=true + journal_mode=off is a non sense for sqlite
>> so engine can't deliver connections
>
> I think I now see what you want: a table saying if you have PRAGMA A set to 
> THIS, then PRAGMA B has no effect.  I do not know of anyone who has made a 
> table like that.  You might be able to work down
>
> http://www.sqlite.org/pragma.html
>
> and make part of one yourself, but I could do no better.
>
> Simon.
>_______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to