[Zope] Stored Procedures Versus ZSQL Methods

2009-02-17 Thread Remy Pinsonnault
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@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] STORED PROCEDURES

2000-10-17 Thread Alejandro Pancani

Hi
I´m using Zope with an Informix Database conected with ZODBC Product and I
need some information about how to call a STORED PROCEDURE
I´m trying to call a STORED PROCEDURE that executes a simple query. I do it
using a ZSQL method, but when i try to test it, i receive the error message
"empty column name". Does anybody have any information about that problem?


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




Re: [Zope] Stored Procedures

2000-10-17 Thread Wolfgang Strobl

Don't do that, P L E E E A S E ! HTML mail doesn't add to the
content of a message in any way, other making them larger and 
harder to read and harder to search for most people.


On 17 Oct 2000, 13:28  Alejandro Pancani wrote:

> This is a multi-part message in MIME format.
> 
> --=_NextPart_000_00EB_01C0383E.16C7E220
> Content-Type: text/plain;
> 
> --=_NextPart_000_00EB_01C0383E.16C7E220
> Content-Type: text/html;
>  charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
> 
> 
> 
> 
__(_)/_(_)___.-._  53754 Sankt Augustin, Germany 

___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] Stored Procedures

2000-10-17 Thread Alejandro Pancani



Hi 
I´m using Zope with an Informix Database conected 
with ZODBC Product and I need some information about how to call a STORED 
PROCEDURE
I´m trying to call a STORED PROCEDURE that executes 
a simple query. I do it using a ZSQL method, but when i try to test it, i 
receive the error message "empty column name". Does anybody have any 
information about that problem?