[Zope] Zope, performance and multithreading (beginner questio ns)

Andy Dustman adustman@comstar.net
Fri, 9 Jul 1999 13:45:40 -0400 (EDT)


On Fri, 9 Jul 1999, Michel Pelletier wrote:

> PS: I'll leave this link here cuz it's cool:
> http://starship.python.net/crew/adustman/MySQLdb.html

Thanx. One caveat: I still consider this module somewhat alpha. That's not
to say it's completely untested. I borrowed/hacked Marc-Andre Lemburg's
test script from mxODBC to thrash multiple client threads (I think I went
up to eight) for more than an hour with no memory leaks or corruption. I
have also had a couple people report that it works. The project that I
wrote the thing for has been somewhat delayed, so I haven't done much
real-life personal testing. It's near-beta. I would have released a beta
the other night but I'm coping with a drive failure at this point and
can't really compile anything. (The only difference between my CVS version
and the one on the Starship are some backslashes in the C to make a
certain DEC compiler happy, and a one-liner in the Python side of the
interface, which makes the rowcount adhere closer to the DB API spec.)

In a nutshell, it's a split interface. The C module (_mysql) adds a little
object abstraction to the standard MySQL interface, and the Python module
(MySQLdb) is a fairly thin wrapper to make it compatible with the DB API.
Conceivably, the ZMySQLDA could use _mysql directly. I see ZxDA as a sort
of alternative DB interface spec anyway, and probably there are a few
things in MySQLdb that aren't needed for ZMySQLDA. This seems pretty
reasonable as the current ZMySQLDA is not using the DB API 1.0 wrapper for
MySQLmodule, so why wrap another wrapper?...

-- 
andy dustman  | programmer/analyst |  comstar communications corporation
telephone: 770.485.6025 / 706.549.7689 | icq: 32922760 | pgp: 0xc72f3f1d