[Zope-DB] Parametric queries
charlie at egenix.com
Fri Jul 29 00:54:00 EDT 2005
On 2005-07-28 at 21:52:28 [+0200], Andreas Jung <lists at andreas-jung.com>
> Not really.
> > (I understand that I can manually make queries via DB-API, but I loose
> > sync with Zope transactions? Anyway I would prefer to use Z SQL Methods)
> I've never had the case where ZSQL methods were *slow* whatever this
> means. There are usually parts inside an application that are slower :-)
> It's nice2have feature but you can live without it.
For the record: the overhead is about 40% on non-cached queries.
Marcin, you will have to write your own ZSQL replacement to do this but
also need a Zope-DA which will work with parametric queries as nearly all
of them to do the quoting à la Zope, and essentially call the .query()
method. Our mxODBCZopeDA does allow *you* to pass parameters in.
Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ... http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::
More information about the Zope-DB