Skip to Content
Former Member
Dec 16, 2003 at 06:09 PM

Long wait time when generate a data load request!



We got a infosource which load data into 3 ods. There are about 700+ requests in each ODS. When trigger the data load with infopackage, the system take like 3 mins to generate a new request number and start that data load. Look like after click start, the system keep scanning system table like RSSELDONE. And, during the data load , the system's performance is very bad. Is this normal? We apply solution 2 of note 620361. The performance issue is solved. Is this how system was designed? Is there any easy way to compress the ods requests to one? It is really not making any sense to copy each ods's data out and reload it back again after certain period of time.Please advise.

Best Regards,