Using the DOM Parser to retrieve data from the XML returned by the SoapAdaptor causes a big slowdown for large XML-s. I had a Query run for 80 Seconds, which in contrast, only took 6 seconds when executed directly in SSMS.
I suggest using a stream oriented SAX Parser instead of the DOM Parser, which would lead to a linear run-time as a function of the XML string's length (it will only be parsed once to read all information nescessary)
I have already made the necessary changes locally for my Project, it seems to work (the same query now only takes 6 seconds using phpolapi, not 80 seconds).
If you are open, I am happy to submit a PR containing all nescessary changes.
Using the DOM Parser to retrieve data from the XML returned by the SoapAdaptor causes a big slowdown for large XML-s. I had a Query run for 80 Seconds, which in contrast, only took 6 seconds when executed directly in SSMS.
I suggest using a stream oriented SAX Parser instead of the DOM Parser, which would lead to a linear run-time as a function of the XML string's length (it will only be parsed once to read all information nescessary)
I have already made the necessary changes locally for my Project, it seems to work (the same query now only takes 6 seconds using phpolapi, not 80 seconds).
If you are open, I am happy to submit a PR containing all nescessary changes.