As I understand it, an SQL DB connection is only a single instance of the connection, and while I can create other instances with the same id in subfolders, I can't at the top level.

For a multithreaded database adaptor, I guess this isn't a problem, but what about a level 1 or 2 adaptor like the MySQL adaptor? Is there some way that I can create several instances of a database connection at the root level (pool connections, not connections with separate ids) so that SQL methods anywhere in the heirarchy can grab whichever one is available? Does zope do this by default and I'm just not aware of it? If so, what are the defaults and how can I change them? It seems like this would be an easy way to improve database performance, but i didn't see it in the docs.