Re: Database Connections

        Hi Duncan,

  Before answering and since I've never used the mod_python and any of
its session management tools, could you please tell:

- which session management module you intend to use?
  (http://www.modpython.org/FAQ/faqw.py?req=all#3.8)

- how does it work? I mean, from a process or thread perspective, can
  you be more explicit?

In short, the answer depends on the answer of those questions; the
EditorContextSessioning component only provides an easy way to register
and retrieve the EC based on a session id. The number of connection to
the database is independent to this component, and is usually 1 (one)
per process (I really mean process here, not threads, a DB connection is
shared by threads within a single process). That's why I asked about the
way mod_python + the session management module you'll use handle
sessions wrt processes.

-- Sébastien.


Duncan McGreggor <[email protected]> wrote:
> Hey Folks,
> 
> We're building an application that uses Modeling, and a couple questions came
> up in a meeting today. The biggest concern was about sessions (what they
> called database pooling or connection pooling). I did have a look at
> EditorContextSessioning, and let them know about it, and it looks like it will
> suite our needs. However, I wanted to get some explicit feedback, just to be
> sure ;-)
> 
> Application Activity: there's going to be lots of querying, searching, and
> updating (the last to a lesser degree).
> Application Framework: Apache + mod_python with the mod_python Session object
> for session management
> 
> What they meant by pooling is not what Oracle developers usually mean; they
> want to be sure that for every HTTP Session, and all of it's HTTP requests,
> there is a single connection to the database that is reused for the entire
> length of the session lifetime.
> 
> Is that, in a nutshell, what we get when we use EditorContextSessioning?
> 
> Thanks!
> 
> Duncan



-------------------------------------------------------
This SF.Net email is sponsored by OSTG. Have you noticed the changes on
Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
one more big change to announce. We are now OSTG- Open Source Technology
Group. Come see the changes on the new OSTG site. www.ostg.com