I have a web app running under mod_python that dynamically builds forms to edit database records which uses the database's constrains pretty extensively to generate FK drop downs and appropriate validation rules. My problem is that as the schema has grown and the inter-table dependencies have become more complex, sa.BoundMetaData() has slowed to the point that it is now taking around 15 seconds to run. Since I instantiate a database connection on every page load, and then read the metadata, this has made the app pretty much unbearable.
I thought about pickling the metadata and reading it in from a cache, but it references a module, which can't be pickled. I looked at pooling the connections, but upon closer inspection, it didn't seem to buy me what I needed. Other than finding some way to cache the metadata within mod_python, is there any quick fix to this? Thanks, e. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
