note 13928 added to function.odbc-connect.php

From: 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

« previous php.notes (#15168) next »