[Zope-DB] Parametric queries

Charlie Clark 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.

Charlie Clark

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 mailing list