News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Brian Moon's Blog:
PHP 5.3 and mysqlnd - Unexpected results
August 05, 2010 @ 10:33:01

On his blog today Brian Moon takes a look at the mysqlnd driver that comes with PHP 5.3 by default and some strangeness he found when trying to fetch results.

I have spoken in the past (see my slides and interview: MySQL Tips and Tricks) about using mysql_unbuffered_query or using mysqli_query with the MYSQLI_USE_RESULT flag [...] So, my natural thought was that using MYSQLI_USE_RESULT with fetch_all would yield the most awesome performance ever. The data would not be buffered and it would get put into a PHP array in C instead of native code.

He had hoped that the fetch_all would cooperate with the MYSQL_USE_RESULT setting, but it seemed to only work with the MYSQLI_STORE_RESULT default. He even filed a bug on the matter which was marked bogus and then reopened. He hopes to show, based on test results, that the result could be much faster.

0 comments voice your opinion now!
mysqldn fetch results bug performance


blog comments powered by Disqus

Similar Posts

Eirik Hoem's Blog: Array problems with SOAP and PHP - Updated

DZone.com: PHP 5.4 features poll: the results

Community News: PHP Remote Exploit - Floating Point Issue Causes Freeze/Crash

Zend Developer Zone: Webinars: Upcoming Zend Webinars (Zend Server, Magento, Performance, IBM i)

Leaseweb Labs Blog: Migration to Symfony2 continued


Community Events





Don't see your event here?
Let us know!


framework laravel opinion security conference voicesoftheelephpant community version tool interview library podcast list language symfony release series introduction composer artisanfiles

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework