XER export considerably slower than XML export in PPM v18.8.24
I have a customer who has started experiencing considerably slower XER export times in PPM v18.8.0 (P6 Professional). I get "Export (Not Responding)" on the "Saving Currency Types..." step at 0% progress bar.
Because of https://support.oracle.com/epmos/faces/DocContentDisplay?id=2735487.1 I upgraded the (EPPM) database from 18.8.0 to 18.8.24 and the PPM client to 18.8.24 and re-tested the XER export. The XER export (on Primavera P6 Pro) is taking multiple hours versus XML export (EPPM on the web portal) which is ~2-5 minutes.
I truncated both the POBS and REFRDEL tables and ran `update statistics` on every table and tested again with no change.
Because of https://support.oracle.com/epmos/faces/DocContentDisplay?id=2735487.1 I upgraded the (EPPM) database from 18.8.0 to 18.8.24 and the PPM client to 18.8.24 and re-tested the XER export. The XER export (on Primavera P6 Pro) is taking multiple hours versus XML export (EPPM on the web portal) which is ~2-5 minutes.
I truncated both the POBS and REFRDEL tables and ran `update statistics` on every table and tested again with no change.
0