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