Re: [Zope] Stored Procedures Versus ZSQL Methods

Cynthia Kiser <[email protected]> Tue, 17 Feb 2009 15:44:49 -0800

Newsgroups	gmane.comp.web.zope.database
Message-ID	<[email protected]>

Quoting [email protected] <[email protected]>:
> 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.