Modified the DBReader and ElementNode classes to more efficiently read documents from the database. In the old implementation, a db connection was opened for each and every node in a document, recursively fromthe root node. In the new implementation, all of the data from xml_nodes is retrieved from the database with a single query and stored in a sorted list of NodeRecord, and the node tree is build from this data structure recursively. This should speed up the document retieval substantially, especially as the document repository grows.
Modified the DBReader and ElementNode classes to more efficiently read
documents from the database. In the old implementation, a db connection
was opened for each and every node in a document, recursively fromthe root
node. In the new implementation, all of the data from xml_nodes is
retrieved from the database with a single query and stored in a
sorted list of NodeRecord, and the node tree is build from this data structure
recursively. This should speed up the document retieval substantially,
especially as the document repository grows.