[Zope] Zope & mySQL

Thomas B. Passin tpassin@mitretek.org
Wed, 6 Feb 2002 16:38:33 -0500


[Tom Nixon]

> Does Zope rely on myODBC to connect to my SQL? How does Zope performance
> compare with PHP for accessing mySQL?
>

Zope can use odbc with it, and there are native drivers too.  Native drivers
ought to be faster (odbc in general is usually said to be slow-ish, though I
haven't made any measurements), but more people seem to have version
mismatch problems with them (i.e., is the driver for python 1.5.2, python
2.1; is the driver multi or single threaded, etc.).

Couldn't say about performance, but if your speed is limited by the
database's retrieval speed, php vs Zope probably won't make any difference.
If it's not so limited, for instance if you open and close a lot of
transactions rapidly, who knows?

Cheers,

Tom P