#36278 [NEW]: extremely slow bytea extraction from pgsql

From: support at kalador dot com Operating system: redhat linux PHP version: 5.1.2 PHP Bug Type: Performance problem Bug description: extremely slow bytea extraction from pgsql Description: ------------ I tried 3 ways to store big images (500K) in database and display in browser. lo works fast, as does using a "text" column and converting the image to base64 (and back for display). However, using bytea with escaping is very slow. Adding to the database is fine (it is fast), retrieving is the problem. Reproduce code: --------------- This code consumed my CPU and took 77 seconds to run for a 400K image: <?php // Connect to the database $dbconn = pg_connect('dbname=imagedb'); // Get the bytea data $res = pg_query("SELECT data FROM image WHERE name='big.gif'"); // Convert to binary and send to the browser header('Content-type: image/gif'); echo pg_unescape_bytea( pg_fetch_result($res,'data') ); ?> Expected result: ---------------- This should take less than 1 second. Using a text column and base64 escaping rather than a bytea column and pg_unescape_bytea takes less than 1 second on the same data. Actual result: -------------- Actually result - 77 seconds. -- Edit bug report at http://bugs.php.net/?id=36278&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=36278&r=trysnapshot44 Try a CVS snapshot (PHP 5.1): http://bugs.php.net/fix.php?id=36278&r=trysnapshot51 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=36278&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=36278&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=36278&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=36278&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=36278&r=needscript Try newer version: http://bugs.php.net/fix.php?id=36278&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=36278&r=support Expected behavior: http://bugs.php.net/fix.php?id=36278&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=36278&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=36278&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=36278&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=36278&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=36278&r=dst IIS Stability: http://bugs.php.net/fix.php?id=36278&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=36278&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=36278&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=36278&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=36278&r=mysqlcfg