Hi Simon, thanks for your reply but try to forget the general introduction of my context .... 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
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 Thanks jerome J.MOLIERE - Mentor/J auteur Eyrolles 2011/9/2 Simon Slavin <slav...@bigfraud.org>: > > On 2 Sep 2011, at 7:39am, jerome moliere wrote: > >> I must give some real clues to my customers to fine tune Sqlite > > 1) What problem(s) are you trying to solve ? > > 2) Must your system be set up for multi-process (or multi-user) access, or > can we ignore all problems concerning those ? > > 3) Are you using transactions to batch together data changes which relate to > one-another ? > > 4) If speed is a problem, do you have indexes defined appropriate to your > commands ? > > 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