note 13928 added to function.odbc-connect.php
| From: | cs at coolspot dot de | Date: | Tue, 10 Jul 2001 17:01:16 +0000 |
| Subject: | note 13928 added to function.odbc-connect.php | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-15168@lists.php.net to get a copy of this message | ||
We've tried hard to connect from php to our IBM DB2 RS/6000 Server. It worked after we compiled
with --ibm-db2= option, but it was unbelievable
slow.
No, just testing some options, we found out that it went from very slow (getting 100 records lasts 1
till 10 seconds) to fast access (almost same speed as with using JDBC from Servlets) to 0.2 till 0.3
seconds.
We simply added the optional parameter Cursortype to odbc_connect, and with the cursortype
SQL_CUR_USE_ODBC it changed in that way!
Hope this helps anybody who must connect to db2 ;)
http://www.php.net/manual//en/function.odbc-connect.php