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
