Hubert-Dudek
Databricks MVP

As of my knowledge, there are not any options to optimize your code. https://github.com/databricks/spark-xml

It is the correct and the only way for reading XMLs, so on the databricks side, there is not much you can do except experiment with other cluster configurations.

Reading multiple small files is always slow. Therefore, it is common to know an issue called the "tiny files problem."

I don't know your architecture, but maybe when XMLs are saved, files can be appended to the previous one (or some trigger could merge them).


My blog: https://databrickster.medium.com/

View solution in original post