On Wed, 5 Nov 2003 16:31:51 +0800 "Yuan, Cain" <[EMAIL PROTECTED]> wrote:
> Hi Kev, > I had a look at the patch and have some questions here: why you > establish a connection to MySQL and then close it in each > function? AFAIK this will put much presure on MySQL if there > are some people to subscribe/unscribe from the list. Why not > just establish a ststic link to MySQL and then use it every time > you need to access the DB? > > Cain Gah! Just running a very big test of this thing, and it seems you're *very* right. By the looks of it, Mailman loads in all of the delivery_status and digest information before it even sends the first mail. Given that, the performance penalty of all those connect/cursor/etc. calls is horrendous, and I need to rethink a little. On the good side, though, I *think* I've got the get/setBounceInfo functions working now, but I've had to import the _BounceInfo class in order to create the appropriate object instance to make it work. Don't know if that's going to be a problem... Current Versionisms: MysqlMemberships.py: 1.24 MysqlMemberships.py.README: 1.15 MysqlMemberships.py.TODO: 1.6 Pondering whether to send a message to mailman-users about this thing, or not. I don't like the prospect of my server getting slashdotted though :( K. -- Kev Green, aka Kyrian. E: kyrian@ore.org WWW: http://kyrian.ore.org/ ISP/Perl/PHP/Linux/Security Contractor, via http://www.orenet.co.uk/ "Love is that condition in which the happiness of another person is essential to your own." R. Heinlein, Stranger in a Strange Land, 1961. -- Kev Green, aka Kyrian. "Be excellent to each other" -- Bill & Ted. Email: kyrian@ore.org Web: http://kyrian.ore.org/ ISP/Perl/PHP/Linux/Security Contractor, via http://www.orenet.co.uk/ _______________________________________________ Mailman-Developers mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-developers
