#30194 [Opn]: Mysqli Prepared Statements work very slow when CLOB\BLOB is in result set
| From: | phoeniks2k at mail dot ru | Date: | Wed, 22 Sep 2004 12:38:08 +0000 |
| Subject: | #30194 [Opn]: Mysqli Prepared Statements work very slow when CLOB\BLOB is in result set | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-66552@lists.php.net to get a copy of this message | ||
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