#46471 [Com]: Performance problem when reading XML columns

From: Date: Mon, 03 Nov 2008 14:24:12 +0000
Subject: #46471 [Com]: Performance problem when reading XML columns
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-130557@lists.php.net to get a copy of this message 
 ID:               46471
 Comment by:       rgpublic at gmx dot net
 Reported By:      rgpublic at gmx dot net
 Status:           Open
 Bug Type:         OCI8 related
 Operating System: Linux
 PHP Version:      5.2.6
 New Comment:

Example source code:

http://oberon.q-one-hosting.com/ocidemo.txt

This script does the following: Create a table with an XML column and
fills it with data. Now, the simple approach to read back the data would
be:

SELECT mytab.xml.getClobVal() AS xml FROM xmltest mytab;

This approach takes about twice the time as the second example which
does the reading inside a PL/SQL function and concatenates the result
separated by a chr(0)-character i.e. transferring the whole data in a
single string. I'm wondering why there is such a loss of performance.


Previous Comments:
------------------------------------------------------------------------

[2008-11-03 14:20:36] rgpublic at gmx dot net

Description:
------------
Reading an XML column seems to be unnecessarily slow.



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


-- 
Edit this bug report at http://bugs.php.net/?id=46471&edit=1

Thread (9 messages)

« previous php.bugs (#130557) next »