RE: [PHP-DB] DB2 Performance issue

2001-10-02 Thread Andrew Hill
Okay, one relevant issue is that PHP sets default cursor type to Dynamic. While this is a nice, potentially bidirectional and sensitive-to-change cursor it can be very expensive, some ODBC drivers don't support it (OpenLink's do) and Dynamic cursors typically dont work with tables lacking a

RE: [PHP-DB] DB2 Performance issue - More Info

2001-10-02 Thread Mark Newnham
From the IBM CLI Reference: SQL_ATTR_ODBC_CURSORS (DB2 CLI v5) This connection attribute is defined by ODBC, but is not supported by DB2 CLI. Any attempt to set or get this attribute will result in an SQLSTATE of HYC00 (Driver not capable). A 32-bit option specifying how the Driver Manager

Re: [PHP-DB] DB2 Performance issue - More Info

2001-10-02 Thread John Lim
Hi Mark, Thanks for the investigation! Will add your comment to the db2 drivers of adodb. Regards, John Mark Newnham [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... From the IBM CLI Reference: SQL_ATTR_ODBC_CURSORS (DB2 CLI v5) This connection attribute is