[Zope-DB] Parametric queries

Andreas Jung lists at andreas-jung.com
Thu Jul 28 15:52:28 EDT 2005

--On 28. Juli 2005 21:26:35 +0200 Marcin Wudarczyk <mar at mar.prv.pl> wrote:

> Hello,
> I've read the manual for Z SQL method and set up a simple example with
> query having a parameter. Everything works fine but then I realised that
> parametric Z SQL Methods are not passing its parameters to DB as
> parameters but inserting it into SQL string. I think this has
> significant impact on perfomance - DBs have special facilities to cache
> compiled queries and change only parameters. Is there a way to use this
> features from Zope?

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.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 186 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zope-db/attachments/20050728/59024ce5/attachment.bin

More information about the Zope-DB mailing list