Re: IBM DB2 on Linux with PHP is very slow

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 code online 56 msg: [IBM][CLI Driver] CLI0150E Driver not capable. SQLSTATE=S1C00 Is there something I must enable? I've been through the DB2 docs and can't find anything related... g 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 > > "Andrew Hill" <ahill@openlinksw.com> schrieb im Newsbeitrag > news:NDBBKFNCBCHANEGAKONKGEBDJBAA.ahill@openlinksw.com... > > Christian, > > > > Are you using an ODBC driver or just the unified-ODBC functions? > > If a driver, then I suggest changing vendors - that performance is in no > way > > representative of ODBC in general. > > In addition, to improve performance even more when using similar queries, > > first use odbc_prepare to prepare a parameter-bound query and then use > > odbc_execute to create the result set for specific parameter values. > > > > You may wish to try our Multi-Tier drivers at > > http://www.openlinksw.com. > > Multi-Tier UDA is exceptionally fast and secure, and downloads with a > free, > > non-expiring 2 user license. > > In addition, free support is available at > > http://www.openlinksw.com/support/suppindx.htm > > > > Please let me know if you require assistance. > > > > Best regards, > > Andrew Hill > > Director of Technology Evangelism > > OpenLink Software http://www.openlinksw.com > > Universal Data Access & Data Integration Technology Providers