[Zope-DB] [Zope] Stored Procedures Versus ZSQL Methods
Cynthia Kiser
cnk+zope at caltech.edu
Tue Feb 17 18:44:49 EST 2009
Quoting JPenny at ykksnap-america.com <JPenny at 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.
More information about the Zope-DB
mailing list