Hi ,
Has anyone generated large XML files using BODS?
We are trying to generate an XML file from a table having around 3.1 Million records. The job is running for around 1 hour and creating the XML file of size 480 MB. Also when the job running the memory consumption is almost 100%.(Around 16 GB).
We notice no Cartesian products in monitor log.The max number in the monitor log is the number of records in source which is 3.1 Million.
Also another strange thing noticed during job run is ,if we start the job at 9 AM it completes writing to the xml file by 9.30, but the job(dataflow) is running until 10 AM without doing anything. Completely clue less on what it is doing these 30 mins. We don’t have the validate xml option checked.
Any suggestions on improving the performance are appreciated.
Thanks
Vams.
mvkreddy15 (BOB member since 2015-05-13)