> 
> 2) the number of connections to the db growing ... is implemented well
>    the MetaData() class ? I'm using postgresql schema's and I want to
>    mantain a single connection for every db user.
> 

Hi!

I had the same problem because I was calling create_engine in every page
request (apache + mod_python). Then I changed it to something like:

g_engine = None

def conn():
    global g_engine
    if not g_engine:
        g_engine = create_engine()
    return g_engine

The module is loaded only once per Apache process.

I hope I directed you the right way :-)

David

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to