Re: Pool Module Question
"Jonathan Ellis" <[email protected]>
| Newsgroups | gmane.comp.python.spyce.general |
|---|---|
| Message-ID | <[email protected]> |
On Sat, 15 Apr 2006 15:41:19 -0600, "Ben Ringold" <ben-3GbDDtM/[email protected]> said: > Alright, so I've upgraded to Spyce 2.0.3, and cached objects are now > being stored correctly in a single pool. > > Now I'm trying to use the pool to maintain several shared MySQL > connections. The connection objects are saved and can be recovered from > the pool. However, when I fish them out of the pool, the connections are > always closed. This is happening both in mod_python and in fcgi. MySQL connections don't pickle nicely. If you're trying to Pool things like that, you'll have to use the proxy server connection to Spyce. OTOH MySQL connections are pretty light-weight, so using something like the SqlAlchemy pool manager with mod_python would probably be okay, even though you'd have more connections around than you really need. -Jonathan -- C++ is history repeated as tragedy. Java is history repeated as farce. --Scott McKay ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642