Yes please see  examples "these are in for loops, but these are the only
occurances of Sqlite in the files in question":

bash script

sqlite3 websites.db "PRAGMA busy_timeout=1500;CREATE TABLE [$SITE] (DATE
INT ,EU INT , US INT);"

php script

$ret = $db->query("PRAGMA busy_timeout=1500;SELECT eu,us,date FROM [$site]
ORDER BY date(DATE) DESC  LIMIT 10");




On Sat, Oct 25, 2014 at 4:12 PM, Stephen Chrzanowski <pontia...@gmail.com>
wrote:

> You did that per connection?
>
> On Sat, Oct 25, 2014 at 10:02 AM, Ali Jawad <alijaw...@gmail.com> wrote:
>
> > 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
> >
> _______________________________________________
> 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

Reply via email to