Bug #47922 [Fbk->NoF]: PDO_SQLITE: reopen database for each update query if no alive results exists

Edit report at https://bugs.php.net/bug.php?id=47922&edit=1 ID: 47922 Updated by: php-bugs@lists.php.net Reported by: homm86 at gmail dot com Summary: PDO_SQLITE: reopen database for each update query if no alive results exists -Status: Feedback +Status: No Feedback Type: Bug Package: PDO SQLite Operating System: * PHP Version: 5.2.9 Assigned To: cmb Private report: N New Comment: No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Re-Opened". Thank you. Previous Comments: ------------------------------------------------------------------------ [2015-09-02 02:18:03] cmb@php.net Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. ------------------------------------------------------------------------ [2009-04-08 08:00:56] homm86 at gmail dot com 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 this bug report at https://bugs.php.net/bug.php?id=47922&edit=1