Hi first time posting to any forum so apologies if I do anything wrong.
We have implemented the following technique for parsing a XML flat file.http://www.oracle-base.com/articles/8i/ ... nts-8i.php
I was wondering if there is any way to reduce the time that the FOR LOOP takes to add new records to the table collection.
What I’m experiencing, I’m going to use employee as an example form the article. If I process 35 employees the average time it takes the FOR LOOP to process is around 1.5 seconds per employee. If we process 120 employees in a file the average time jumps to over 5 seconds an employee. So when we get to processing around 500 employees the process is taking about 4 ½ hours to complete.
When I did my test remove the insert to Oracle table code.
We are using 8i database.
Is that just the natural of the beast or can I do anything to improve the loading of the table collection?
Thanks in advance for any help that is provide.