Bug #66875 [Opn->Csd]: Increasing performance in lob fecthing by x2
| From: | sixd@php.net | Date: | Mon, 10 Mar 2014 23:47:33 +0000 |
| Subject: | Bug #66875 [Opn->Csd]: Increasing performance in lob fecthing by x2 | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-184700@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=66875&edit=1
ID: 66875
Updated by: sixd@php.net
Reported by: perrier dot p at gmail dot com
Summary: Increasing performance in lob fecthing by x2
-Status: Open
+Status: Closed
Type: Bug
Package: OCI8 related
Operating System: irrelevant
PHP Version: Irrelevant
Block user comment: N
Private report: N
New Comment:
Automatic comment on behalf of sixd
Revision: http://git.php.net/?p=php-src.git;a=commit;h=601367ee75c570b52ac8f28c7b26d5166cad2989
Log: Fixed Bug #66875 (Improve performance of multi-row OCI_RETURN_LOB queries)
Previous Comments:
------------------------------------------------------------------------
[2014-03-10 09:37:19] perrier dot p at gmail dot com
Description:
------------
chunk_size from a lob is loaded for each column and each line, but can be defined only for each
column in ORACLE, so we can make a cache of chunk_size in column object instead of fetching it on
every lob.
With this change you can increase by a factor x2 the lob fecthing part of a query.
Patch is made from PHP 5.5.5 source code.
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=66875&edit=1