With this weekend being year end I've got to upload new price lists for the new financial year.

The upload will be done using a new session that has been developed for us, updating the tdpur032, tdsls030, tdsls032 and tdsls037 tables.

I have run a test upload on our pre-prod server and the process took around 11 hours. I want to see if I can cut this time down in anyway.

Can anybody recommend ways to make "tweaks" that could assist me in making this process quicker.

Thanks

PJ

ba6.1 -- -set RDS_FULL=1000 -set ORA_MAX_ARRAY_INSERT=1000

This works only if you have enable the array interface.

Regards,
Han