make sure web2py doesn't handle migrations if you have users hitting your application. Don't know if there's a connection timeout check in psycopg2, that can eb set to 3 min and it auto-checks if every call to the database remains withing the limits you set....
Il giorno lunedì 17 giugno 2013 11:20:25 UTC+2, hiro ha scritto: > > I am using the DAL to connect to a Postgres server. This server is very > big and under constant heavy load. > > The problem I am experiencing is that from time to time when the server is > under really heavy load, or when the tables queried from the DAL are > currently being recreated, the server just wait. > > This causes web2py to just wait as well and if the user try to make a few > of these calls the web2py server just dies and I have to restart it. > > What I would like is some way of making sure no query take more than 3 > seconds. If they do the query should be aborted and and error should be > raised. What is the best way to implement this? > > > > -- --- 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.
