Re: [PHP-DB] IBM DB2 on Linux with PHP is very slow

2001-07-16 Thread Glenn Butcher
I'm experiencing slowness in the fetching of result sets. I set the cursortype parameter as suggested by Christian Szardenings to SQL_CUR_USE_ODBC, and I get the following: Warning: SQL error: [IBM][CLI Driver] CLI0150E Driver not capable. SQLSTATE=S1C00, SQL state S1C00 in SQLSetConnectOption i

Re: [PHP-DB] IBM DB2 on Linux with PHP is very slow

2001-07-13 Thread Glenn Butcher
I just tried the Cursortype parameter (apache-1.3.20+php-4.0.6, DB2-7.1), but I get this message: Warning: SQL error: [IBM][CLI Driver] CLI0150E Driver not capable. SQLSTATE=S1C00, SQL state S1C00 in SQLSetConnectOption in /home/butcher/public_html/php/service_portal/content.php(68) : eval()'d co

Re: [PHP-DB] IBM DB2 on Linux with PHP is very slow

2001-07-10 Thread Christian Szardenings
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 t

RE: [PHP-DB] IBM DB2 on Linux with PHP is very slow

2001-07-10 Thread Andrew Hill
ders > -Original Message- > From: news.php.net [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 09, 2001 5:59 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] IBM DB2 on Linux with PHP is very slow > > > > Hi, > > does someone has a DB2 UDB from IBM working with > PHP

[PHP-DB] IBM DB2 on Linux with PHP is very slow

2001-07-09 Thread news.php.net
Hi, does someone has a DB2 UDB from IBM working with PHP in a production envirement ? How is the performance? For a relaunch of our existing production system running on IBM DB2 on serveral IBM RS/6000 servers we tested the performance of connecting PHP to this database. And what can I say: It