[Webware-discuss] Re: Middle Kit didn't closing connections?

[Martin V. <vi...@gm...>]

> From: Bogdan <bo...@tu...>
> To: web...@li...
> Organization: MSHRC
> Subject: [Webware-discuss] Middle Kit didn't closing connections?
>

> I get this connections when using middle kit from webware 8, and with
> each referring to db I getting more and more same strings.

I have found the same problem, and I have also found that it started when I upgraded to 0.8. Fortunately, the solution is simple: just enable the SQL Connection pool in Settings.config


http://webware.sourceforge.net/Webware-0.8/MiddleKit/Docs/UsersGuide.html


--------------------------------------snip

The SQLConnectionPoolSize setting is used to create a MiscUtils.DBPool instance for use by the store. For DB API modules with a threadsafety of only 1 (such as MySQLdb), this is particularly useful (in one benchmark, the speed up was 15 - 20%). Simply set the size of the pool in order to have one created and used:

{
'SQLConnectionPoolSize': 20,
}

-------------------------------------snip


-- Martin Virtel
vi...@gm...
aim / yahoo messenger mvftd
tel. +49 177 242 2889