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 [Zope] Stored Procedures Versus ZSQL Methods 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 procedures will allow better performance? Thanks in advance Rémy_______________________________________________ Zope maillist - z...@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) _______________________________________________ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
