Yes, with a stored procedure the DB does not have to reparse and
prepare a new plan for every query. This can be a major win. Esp.
on Oracle.
Remy Pinsonnault remypinsonna...@gmail.com
Sent by: zope-boun...@zope.org
02/17/2009 06:37 PM
To
zope-db@zope.org, z...@zope.org
cc
Subject
No, ZSQL really predates bind variables. That is, they we
available on a few systems, but were rare. If the Oracle
specialist has a reason for going to external methods, like
his server is seriously loaded, I would pay attention to him.
If he is just following some set of best practices, well,
I also have a broader question: When one is composing dynamic SQL in
Python
scripts, what are the pros and cons of executing them by going directly
to
the database adapter (as suggested above) vs passing it in as the sole
argument of an empty ZSQL method? By empty ZQL method I mean
An alternative is:
select * from students
where surname like '%dtml-var surname sql_quote%'
This is a bit more succinct, but if you use it, be sure not to
forget the sql_quote, or you will be open to sql injection problems.
jim penny
[EMAIL PROTECTED] wrote on 02/16/2007 02:57:37 AM:
On Fri,