>> 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
