JPenny at ykksnap-america
Feb 17, 2009, 3:40 PM
Views: 1578
Permalink
|
|
Re: [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 <remypinsonnault[at]gmail.com>
Sent by: zope-bounces[at]zope.org
02/17/2009 06:37 PM
To
zope-db[at]zope.org, zope[at]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 - Zope[at]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[at]zope.org
http://mail.zope.org/mailman/listinfo/zope-db
|
Re: [Zope] Stored Procedures Versus ZSQL Methods
