6 Feb
2002
6 Feb
'02
9:38 p.m.
[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