> I found no appropriate documenation in the net > considering pooling of database connections. > So, how can I pool connections ?
Take a look at MiscUtils.DBPool. I use it for postgres and it works great. You can subclass it as needed to turn off transaction mode, or whatever. I have a file called SiteDatabase.py that creates an instance of a DBPool in the module scope (global?), and any servlet or other class can import it, thus sharing my pool. > Is it a good idea to store a connection > in the session() (timeout 60secs) so > that during a session database acess > is accelerated ??? Probably not. If you had lots of users, they would each get a connection and you'd run out of resources on your database. > Last questions: when are servelt instances > created ? I'll leave that for the gurus :) ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Webware-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-devel
