[Zope-DB] DCOracle2 cursor.execute is getting incredible slow

[Willi Langenberger]

According to Matthew T. Kromer:
> I think there's a leak in the binary, but it is fixed in the CVS 
> source, where the parameters for the describe are never freed.
> 
> Try building from the latest CVS source and you should be OK.

Wow, great! Thank you, Matt, it really solved my problem!

For the record: it was this innocent looking patch for dco2.c:

diff -u dco2.c.ori dco2.c
[...]
@@ -3489,6 +3545,15 @@
        status = OCI_SUCCESS;
 
        for (pos = 1; status == OCI_SUCCESS; pos++) {
+
+             if (paramd != NULL) {
+                   TRACE(T_HCALL,("ssA","OCIDescriptorFree","OCI_DTYPE_PARAM",
+                           paramd));
+                   status = OCIDescriptorFree(paramd, OCI_DTYPE_PARAM);
+                   TRACE(T_HRETURN,("sR","OCIDescriptorFree", status));
+                   paramd = NULL;
+             }
+


Thanks again!


\wlang{}

-- 
Willi.Langenberger at wu-wien.ac.at                Fax: +43/1/31336/9207
Zentrum fuer Informatikdienste, Wirtschaftsuniversitaet Wien, Austria