Along with the release of Christmas edition of the Ingres database workbench a new version of the Ingres PHP driver has been posted.
2.0.1 is major/minor release in as much as it is just a bunch of bug fixes but includes some important changes. From the CHANGELOG here are what I believe are the two most notable updates:
- Improved performance by batch fetching rows – the ingres_fetch_*() functions will now retrieve upto 100 rows from the server, reducing the network traffic required to fetch those same 100 rows, one at a time. Whether the DBMS engine provides 100 rows is another matter as this is dependant upon the width of the row and the ability to make good use of the GCA packet. Performance improvements of between 2 and 30 times have been observed. YMMV…
- Improved interoperability when working with older Ingres releases – some time in the past interoperability between versions of Ingres broke when using the PHP driver. Driver functionality is based on the Ingres release against which it is built. For example Ingres 9.2.0 introduced bi-directional scrollable cursor support. When the driver was build against 9.2.0 but connected to an earlier release of Ingres it did not know that the DBMS engine could not provide that feature. The driver is now “aware” of the capabilities of the server to which it is connected and will only use features supported in that engine.
And now for some links:
- README.html – http://cvs.php.net/viewvc.cgi/pecl/ingres/README.html?view=co&pathrev=RELEASE_2_0_1
- Source code – http://pecl.ingres.net/get/ingres
- Windows DLLs – Since http://pecl4win.php.net is no longer being updated, I have made available DLLs for PHP 5.1.6, 5.2.6 and 5.2.8 for Ingres 2.6/0305, 9.0.4, 9.1.1, 9.2.0 and 9.3.0 at http://esd.ingres.com/product/drivers/PHP/Windows_32-Bit/PHP_Driver
As always if you experience any problems with the driver you can email me via grant @ php dot net, or raise and issue via Servicedesk.
Feliz Navidad a todos
grant
