Hi,
I'm using SAContext to manage my SQLAlchemy database connections. Today
setup looks like this.
BaseController.__call__:
model.sac.session.clear()
self.db = model.DatabaseFacade()
And DatabaseFacade.__init__:
self.session = sac.session
self.meta = sac.get_metadata("blog")
Basically, I create an instance of DatabaseFacade for every web request and
DatabaseFacade relies on sac.session to manage db conn.
Is it optimal setup? What if make a DatabaseFacade created just once,
instead of per-request? Would it remain thread-safe?
I mainly ask because I was thinking about cache some database data and for
this to more I need a permanent facade instance.
I also realise that suboptimal setup and concurrency problems may be not
obvious until the site got high load...
Thanks,
Max.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"pylons-discuss" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/pylons-discuss?hl=en
-~----------~----~----~----~------~----~------~--~---
