Thanks for the input, I did add PRAGMA busy_timeout=1500; before any query but I am still getting loads of locked database errors, please advice
On Mon, Oct 20, 2014 at 3:44 AM, Keith Medcalf <kmedc...@dessus.com> wrote: > > Actually, you should set the timeout for each connection. The computer > does not matter. > > >-----Original Message----- > >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > >boun...@sqlite.org] On Behalf Of Simon Slavin > >Sent: Sunday, 19 October, 2014 18:35 > >To: General Discussion of SQLite Database > >Subject: Re: [sqlite] Question on locks > > > > > >On 20 Oct 2014, at 1:15am, Ali Jawad <alijaw...@gmail.com> wrote: > > > >> Thanks, I hope it works, I hate to use MySQL for this project. Pardon > >my > >> ignorance but the example at hand below is for C, any ideas on how to > >set > >> for Bash and PHP ? Or better yet globally for sqlite3 > > > >There's a PRAGMA which sets the same thing: > > > ><http://www.sqlite.org/pragma.html#pragma_busy_timeout> > > > >The time is in milliseconds and for testing purposes you want to set it > >to at least 10000 milliseconds. > > > >Execute the pragma after you open the connection /on all the computers > >which are opening the database/. > > > >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
