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
