so, you're writing to the db for every page every user hits. expect other lockings, even with SQLite with WAL.
On Saturday, April 6, 2013 3:41:26 PM UTC+2, BlueShadow wrote: > > I did check the version: 3.7.9 > So it should be fine. > I got very little db writes like I said 30 users a day and incresing an > integer per page view is about all I do. > > > On Saturday, April 6, 2013 3:29:24 PM UTC+2, Vasile Ermicioi wrote: >> >> Don't really know where you saw the 100k user statement.... >> >> http://www.sqlite.org/whentouse.html >> >> for every request you are issuing that query.... once WAL is active, >>> there's no further need to issue that statement >> >> I agree, +1 >> >> editing a single table from multiple users ... no. >> >> with WAL enabled the response is YES! >> >> >> it looks like he is using a version of sqlite that doesn't support wal, >> python and pypy default installation are using version 3.6.xx >> but WAL requires sqlite version 3.7+ >> >> check that from python >> import sqlite3 >> print sqlite3.sqlite_version >> >> and upgrade your sqlite lib >> >> >> -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
