hi, I use dal standalone with gevent for a high io bound program, there are thousands of users each with his own database (mysql), I update some tables with info from the web, and to make it fast I use a few hundreds greenlets, that means each has a db (DAL) object, which use a db connection
how to use only a few connections with dal, or what I need to change to do so even if that means to use just one connection, database operations are much faster so it doesn't affect too much overall performance usin pool_size doesn't help because it reuse connections for the same connection string, that means it can use a few connections for the same database, but I need a pool for all databases
