ID: 30194 User updated by: phoeniks2k at mail dot ru Reported By: phoeniks2k at mail dot ru Status: Open Bug Type: Performance problem Operating System: All PHP Version: 5.0.1 New Comment:
Sorry, some additional info: Mysql 4.1.4 Gamma and clobs are not empty Previous Comments: ------------------------------------------------------------------------ [2004-09-22 14:27:20] phoeniks2k at mail dot ru Description: ------------ If result set has clob\blob fields, retrieving data is VERY slow. Query "SELECT SQL_NO_CACHE id, xml_clob FROM some_table WHERE id = 1" executes 1000 times for about 0.4 seconds on my server; But this query rewriten with statement execs 20 time for 6(!) seconds!!! Every time i call: exec, store result, fetch, free_result P.S. SQL_NO_CACHE is used for clean noncached result times Expected result: ---------------- STMT performance higher then normal query performance ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=30194&edit=1
