It may also depend on what database you are using. With MySQL, I have not seen any speed-up when using a pool, so I've done away with it and just create a new connection each time.
Quoting Christoph Zwerschke <[EMAIL PROTECTED]>: > > Reading the webware doc and website, I found nothing to take care about > > external connections handling. > > Do I have to manage my own opened connections pool which is accessed by > > all threads concurrently? > > Should there be a connection per thread? > > Is there a Thread instance, so I can store a connection handler? > > There are two possibilities. Either as you suggested, you create one > connection per thread, or you use a connection pool. The former makes > sense when you configure Webware in AppServer.config with a fixed number > of threads. If it is configured dynamic, so that threads are constantly > created and destroyed, it is better to use the connection pool approach. > > MiscUtils.DBPool provides a simple connection pool. DBUtils > (www.w4py.org/DBUtils) provides a more sophisticated solution and > support for both, connection pool and thread affine connections. > > -- Christoph > > > ------------------------------------------------------- > 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 > _______________________________________________ > Webware-discuss mailing list > Webware-discuss@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/webware-discuss > ---------------------------------------- This mail sent through www.mywaterloo.ca ------------------------------------------------------- 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 _______________________________________________ Webware-discuss mailing list Webware-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/webware-discuss
