RE: SV: [PHP4BETA] Easier Porting To Different Databases

Somewhat off topic, but regarding the 'slowness' of ODBC. It's really not the main business of db vendors to produce fast or SQL92 compliant drivers - more of afterthough. Given an _appropriate_ implementation of ODBC, you will see a great deal of performance improvement. To this end, Openlink will be releasing an open source benchmarking tool in a few weeks, that will allow you to line up any driver, and databases, any platforms, and 'horse-race' them across several benchmarking tests. It will be open source to allow contribution and to eliminate and concern that our drivers outperform other due to a tweaked test :) We are also actively working with different components of the linux community to help create an embedded ODBC data abstraction layer under linux/unix, similar to the ones that exist by default under Windows (ODBC Data Source Administrator). They will, of course, be open source. The basis for this will be iODBC, and include load testing, accelerated development and benchmarking utilities as well. The release of benchmarking utility (GTKBench) should coincide with the release of Openlinks 3.5 drivers, due out by the end of March. Best regards, Andrew ---------------------------------------------------- Andrew Hill Technical Support Consultant OpenLink Software http://www.openlinksw.com Universal Database Connectivity Technology Providers -----Original Message----- From: nick@sif.easysoft.com [mailto:nick@sif.easysoft.com]On Behalf Of Nick Gorham Sent: Wednesday, March 01, 2000 6:24 PM To: Johan Ekenberg Cc: ahill@openlinksw.com; php4beta@lists.php.net Subject: Re: SV: [PHP4BETA] Easier Porting To Different Databases Johan Ekenberg wrote: > In my experience ODBC is *a lot* slower than > direct interfaces. If Perl DBI can do without ODBC, > I really hope PHP can too. > For instance, see the benchmarks at > http://www.mysql.com/benchmark.html Well looking at those benchmarks, ODBC is only involved in the Oracle graph. Of course ODBC will be slower in many cases, it involves additional layers to provide a unified interface. But remember this thread is discussing adding another layer to PHP to interface between whatever the final unified API may be and the underlying interface, this will also slow things down, as to it being quicker or slower than ODBC it remains to be seen. IMHO most of the 'slow' ODBC drivers seem to come from vendors who wish to retain control over their own API's (see Oracle example above) Whatever the final API, it will have to face the same problems and restriction that the ODBC design had to face, but it may only have to implement a much simpler set of calls in this case. -- Nick Gorham, nick@lurcher.org Found in a sig... Give a man a match and he'll be warm for an hour... Set him on fire and he'll be warm for the rest of his life. -- PHP 4.0 Beta Mailing List <http://www.php.net/version4/> To unsubscribe, e-mail: php4beta-unsubscribe@lists.php.net For additional commands, e-mail: php4beta-help@lists.php.net To contact the list administrators, e-mail: php4beta-admin@lists.php.net