I think I was looking at the BoundMetaData call while we were having database problems, that doesn't seem to be the core of the problem. Ignore this for now, please. Thanks.
Eric Brunson wrote: > 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 -~----------~----~----~----~------~----~------~--~---
