mahendra.nepali@... wrote:

>
> To speed up the process I load lots of data into temp tables and then
> delete the records from them for each xml file I load.

In what sense does that speed up the load process? From my rough
calculation, it approximately triples the amount of work done.
First you store the records. Then you store the records again.
Then you delete the records in the temp table. Why?


Regards,


Ann