This is not a problem, but I would like to confirm that this pseudo code is best practice.
I have a single instance of web2py (2.13.4) with multiple applications, each application has its own MySQL database. 'init' is my control application which I use for administration. In 'init' I want to access each of the other applications' databases. for each app in applications: db_app = DAL(app_uri, pool_size=5, ...) .......... read/write to db_app .......... db_app.commit() db_app.close() During testing I stressed this loop without a problem: for i in range(200): for each app in applications: db_app = DAL(app_uri, pool_size=5, ...) .......... read/write to db_app .......... db_app.commit() db_app.close() Without the db_app.close() it would fail by running out of connections. Is there anything about this approach I should be concerned with? Will the db_app.close() affect other users in the applications? Thank-you for your advice! -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
