[Zope-DB] Parametric queries
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:
> 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?
> (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
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