[Zope-DB] 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-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] [Zope] Stored Procedures Versus ZSQL Methods
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
Re: [Zope-DB] [Zope] Stored Procedures Versus ZSQL Methods
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, that is a political problem for Remy. Using external methods will be more work for the zope writer. I don't know enough to comment seriously on security issues, but I think that using procedures, like using bind variables, will make SQL Injection much harder. Cynthia Kiser cnk+z...@caltech.edu 02/17/2009 06:44 PM To jpe...@ykksnap-america.com cc Remy Pinsonnault remypinsonna...@gmail.com, zope-db@zope.org Subject Re: [Zope-DB] [Zope] Stored Procedures Versus ZSQL Methods Quoting jpe...@ykksnap-america.com jpe...@ykksnap-america.com: 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. Does ZSQL allow the use of bind variables? If so and the database has a correctly sized query cache, there shouldn't be much reparsing for repeated queries. ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db