Hi,
i got a couple of errors today which tell me the database is locked. I know
I'm using sqlite. which is less than ideal. I got about 30 users a day
which should be perfectly fine with SQLite.
Especially since I added this part of code:
if not request.env.web2py_runtime_gae:
## if NOT running on Google App Engine use SQLite or other DB
db = DAL('sqlite://storage.sqlite', migrate=False)
try:
db.executesql("PRAGMA journal_mode=WAL;")
except:
pass
Or do I have to add something else to enable the write ahead option?
from the things I read SQLite should be usable upto 100k Users a day with
this WAL.
I tired to migrate to postgresql but since there are a couple things which
are not allowed in postgres (for example: Field "Content") I have to move
the db manually which will have to wait quite a bit.
--
---
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.
