>-----Urspr�ngliche Nachricht----- >Von: Matthias S�� [mailto:matthias.suess@;allizom.com] >Gesendet: Dienstag, 22. Oktober 2002 16:54 >An: Rupsch, Alexander ECG >Betreff: Re: SAPDB slow on joins? > > >Hi Alexander! > >You have compiled Postgres in your PHP? ODBC is alway slower than a >native interface. :-) Why don�t you compile SAPDB in your interpreter?
At first two citations why i did ;-) [cit. www.sapdb.org/sap_db_program.htm] >From version 4.0.3, PHP 4 accesses SAP DB via PHP's Unified ODBC and the SAP DB ODBC-driver. Similar to Perl, this can be performed using a driver manager.(Thanks to A. Karajannis of the the PHP-ODBC module team). [cit. http://www.sapdb.org/sap_db_FAQ.htm] Is there a C-API to access SAP DB? ODBC is the official C-API. There is no performance loss because ODBC is not implemented as a wrapper around a lower level API. In Unix, programmers can use either one of the available driver managers or link them directly with the libraries provided with SAP DB. So there is no PHP support for SAPDB, ins't it? Aside from this, there ist almost nothing in the result set (count(*)) so ODBC has almost nothing to transport. There are other selects which match to 50% of the entries which performed at the same speed as PGSQL (all count(*), the benchs is not about the data transport...). I use iODBC as drivermanager. I think SAPDB has it's own drivermanager (Am I right?), I didn't try to use it, but i think that's not the problem, because the driver is the same and there is no data to transport. Well, it is some kind of unfair to compair ODBC with a native support, but that's the only interface supported. But I think that's not the point. ;-) _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
