My guess would be that you're using sqlite and the database is locking you. 
Which is easy to happen if you have a few people requesting updates every 5 
seconds and you're trying to write on it, as the write will only go forward 
once sqlite gets its process an EXCLUSIVE lock which requires all readers 
which have SHARED locks to stop reading first.

One thing you can do is to cache the result returned in the first case so 
it doesn't hit the database. Then you can clear the cache when you make 
changes that would change the result. If this doesn't work then it's time 
to change databases.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
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 [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to