FAQ
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@gmail.com
-Summary: Increasing performance in lob fecthing by x2
+Summary: Increasing performance of LOB fetching
  Status: Closed
  Type: Bug
  Package: OCI8 related
  Operating System: irrelevant
  PHP Version: Irrelevant
-Assigned To:
+Assigned To: sixd
  Block user comment: N
  Private report: N

  New Comment:

The performance benefit will be system dependent. I had to fetch 4K
rows before I could begin to measure any time improvement from caching
OCILobGetChunkSize()'s value. Since OCILobCharSetId doesn't involve a
network trip, caching its value seems to add more obscurity then it's
worth.

A patch was merged to PHP 5.6+. See http://news.php.net/php.cvs/76429
and
https://github.com/php/php-src/commit/de4ff2c5a42980645baf731200840c56d6a75275
Can you check it before I release OCI8 2.0.8 on PECL?

Patch description: The patch caches the result of OCILobGetChunkSize()
to avoid a DB round trip for the second and subsequent rows fetched
when using PHP's OCI_RETURN_LOBS. This will help overall scalability.

Implementing similar caching for LOB locator fetches using
OCI-Lob::read() and OCI-Lob::load() might be possible, but would
require a more complex patch.


Previous Comments:
------------------------------------------------------------------------
[2014-03-10 23:47:33] sixd@php.net

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)

------------------------------------------------------------------------
[2014-03-10 09:37:19] perrier dot p@gmail.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.



------------------------------------------------------------------------

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 4 | next ›
Discussion Overview
groupphp-bugs @
categoriesphp
postedMar 10, '14 at 9:37a
activeMar 11, '14 at 8:25a
posts4
users2
websitephp.net

People

Translate

site design / logo © 2019 Grokbase