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 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 uses the ODBC cursor
library.
So I guess this means the message below was related to using a 3rd party
odbc driver.
Shucks..
Regards
Mark
-Original Message-
From: Mark Newnham [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 01, 2001 3:33 PM
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] DB2 Performance issue
This was posted on the newsgroup a couple of months ago:
Christian Szardenings wrote:
Hi Andrew,
thanks a lot for your help. Today we discovered what
our real problem was:
After playing a little bit with the php-scripts that try
to connect to the IBM DB2, we set the optional parameter
Cursortype when calling odbc_pconnect().
And the exciting thing: When we set the cursor type
to SQL_CUR_USE_ODBC Cursor Type, then
the whole query speed up from 1 till 10 seconds
to 0.2 till 0.3 seconds for 100 records. Amazing!!!
Therfore, PHP is just almost fast as calling the DB2
from Servlets using JDBC (don't take too much care
about the speed at whole: the database was on a
completely other location, so the whole connection
was made over a slow network connection).
I hope this helps when other encounter the same
problem when trying to connect to DB2 from
PHP.
Kind regards,
Christian Szardenings
This posting has caused some discussion amongst some of us
who are trying to
use DB2 in Native mode (i.e. using Unified ODBC) as the IBM
driver manager
appears not to support this parameter. ( An odbc connect with
the specified
parameter returns [IBM][CLI Driver] CLI0150E Driver not capable.
SQLSTATE=S1C00
Could the author or anyone else who knows, please clarify
this posting if
they are using unified odbc or perhaps a third party ODBC driver.
TIA
Mark
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]