All,
I need to write a back-end module(import feature)which receives XML data containing entire data dump(around 10,000 records)and same shall be updated into database. Updating database involves insert/update/delete records in 10 tables. Import need to be done every night(off peak hour). My design is as follows,
1. Write 10 CMPs for 10 tables
2. Relate CMPs using CMR
3. Use Local Interfaces to improve performance
Since lot of things are changed in CMP2.0, I feel performance will NOT be an issue with CMP.
What do you feel? This is very urgent, please provide your comments at the earliest.
~Prasanna
----------