| 8 | | |
| 9 | | Replying to [comment:8 cboos]: |
| 10 | | > Using a pool of database connections is a common way to limit the amount of resources used (never use more than the max specified number of concurrent connections) and at the same time to be more reactive (most of the time, there's already an open connection waiting to be used). |
| 11 | | > |
| 12 | | > That being said, you can experiment with having a connection per query, and if this proves more convenient in the case of MySQL, we could make that configurable. |
| 13 | | > |
| 14 | | > {{{ |
| 15 | | > Index: trac/db/mysql_backend.py |
| 16 | | > =================================================================== |
| 17 | | > --- trac/db/mysql_backend.py (revision 3968) |
| 18 | | > +++ trac/db/mysql_backend.py (working copy) |
| 19 | | > @@ -99,7 +99,7 @@ |
| 20 | | > class MySQLConnection(ConnectionWrapper): |
| 21 | | > """Connection wrapper for MySQL.""" |
| 22 | | > |
| 23 | | > - poolable = True |
| 24 | | > + poolable = False |
| 25 | | > |
| 26 | | > def _mysqldb_gt_or_eq(self, v): |
| 27 | | > """This function checks whether the version of python-mysqldb |
| 28 | | > }}} |
