Hello, After reading more carefully the documentation I found that, but I want to create a db where I'm having just one writer and multiple readers, but I need that the readers never get "db locked" when they are reading so I thought using WAL journal_mode.
But how can I create a WAL db? Many thanks, Vitor. Vitor Rosa Corporate Relations Local BEST Group Almada Faculdade de Ciências e Tecnologia da Universidade Nova de Lisboa +351 965 707 240 2013/3/14 Richard Hipp <d...@sqlite.org> > On Wed, Mar 13, 2013 at 12:45 PM, Vitor Rosa <v.r...@campus.fct.unl.pt > >wrote: > > > Hello, > > > > I'm using windows 7 (64 bits) with sqlite 3.7.15.2 and I can't change > > journal_mode to WAL, it always return memory mode. > > what I can do? > > > > For an in-memory database, the only allowed journal modes are OFF and > MEMORY. Are you trying to change the journal mode to WAL on an in-memory > database? > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > 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