Hello Community,

used Software:
- hibernate 3.6
- sqlite jbdc 3.6.0
- java jre 1.6.X

i have following problem:
- We transfer data over a tcp connection ( 20 000 entrys )
- we create a sqlite database with the help of hibernate
- we use hibernateview and hibernate annotations to create querys
- hibernate proberties are also used
- storing 20 000 entries with hibernate and NO sqlite pragmas enabled lasts nearly 6 minutes ( ~ 330 sec) on Windows 7
- storing 20 000 entries without hibernate and all relevant sql pragmas enabled lasts ca 2 minutes ( ~ 109 sec ) on windows 7
- tests with hibernate and sqlite without pragmas on windows XP and windows Vista run fast, but on win7 it lasts nearly
3 times ( ~ 330 sec - win 7) as long as on the XP machine
- on windows 7 we want to activate sqlite pragmas to gain speed boost
- relevant pragmas are:
PRAGMA cache_size = 400000;
PRAGMA synchronous = OFF;
PRAGMA count_changes = OFF;
PRAGMA temp_store = MEMORY;
PRAGMA auto_vacuum = NONE;

- problem: we must use hibernate ( no Nhibernate ! )

- quesion:
- how to enable these pragmas in hibernate sqlite connection? is this possible? Please tell me how its done.
- is it possible to do so with using hibernate?



Many Thanks,
Sebastian