Hello,
We have a Zope application with thousands of Z SQL methods connected to an
Oracle Database.
Our DBA want us to develop our new applications using stored procedures
called through external methods, instead of using directly Z SQL methods,
for performance issues and memory usage.
Do stored
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,