This question is in regard to Tim's article 'Parse XML Documents' (https://oracle-base.com/articles/8i/ ... nts-8i.php).
We have developed the program in Oracle 8i using the method mentioned in the link however we are facing some performance issues when the records in the XML file increase in number.
In this article it has been mentioned that ' -- Form better performance multiple collections should be used to allow bulk binding using the FORALL construct but this would make the code too long-winded for this example.'. Can somebody provide me with an example where FORALL construct has been used and is giving a good performance.
Thanks in advance.
The bulk-bind will only improve the speed of the inserts, not the parsing of the document. You can see how bulk binds work in 8i here:
https://oracle-base.com/articles/8i/ ... nds-8i.php
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 1 guest