Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001071

Re: [PHP-DB] IBM DB2 on Linux with PHP is very slow From: Glenn Butcher (butcher <email protected>)
Date: 07/13/01

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 <email protected>> schrieb im Newsbeitrag
> news:NDBBKFNCBCHANEGAKONKGEBDJBAA.ahill <email protected>
> > 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 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>