From: homm86 at gmail dot com Operating system: all PHP version: 5.2.9 PHP Bug Type: PDO related Bug description: sqlite reopen database for each update query if no alive results exists
Description: ------------ Database begin slow down on simple queries, such as INSERT, UPDATE, DELETE. This is paradox, but sqlite slowdown updates when not alive results in memory presence. If we have alive result with non-zero count of elements, updates runs very fast. The only difference between two passages in example is unset($helper), but this gives more then 150x slowdown. I also notice hi disk usage while operation. I think driver in second pass reopen database for write. Reproduce code: --------------- http://pastebin.com/f595e2031 Expected result: ---------------- I want same time for both passages. Actual result: -------------- Results different on 150 times. 0.0336790084839 5.47776293755 -- Edit bug report at http://bugs.php.net/?id=47922&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=47922&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=47922&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=47922&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=47922&r=fixedcvs Fixed in CVS and need be documented: http://bugs.php.net/fix.php?id=47922&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=47922&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=47922&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=47922&r=needscript Try newer version: http://bugs.php.net/fix.php?id=47922&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=47922&r=support Expected behavior: http://bugs.php.net/fix.php?id=47922&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=47922&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=47922&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=47922&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=47922&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=47922&r=dst IIS Stability: http://bugs.php.net/fix.php?id=47922&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=47922&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=47922&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=47922&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=47922&r=mysqlcfg
