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 <[email protected]>
wrote:
> You did that per connection?
>
> On Sat, Oct 25, 2014 at 10:02 AM, Ali Jawad <[email protected]> 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
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
