I am using OracleXMLQuery to retrieve XML from our database and need to retrieve the total number of records in the XML. I am currently using the XPath count() function, but it takes too long for large queries. Is there a faster way to get the record count from the XML? Thanks.
posted 14 years ago
In case anyone else ever has this question... If you are using OracleXMLQuery you can run the method getNumRowsProcessed() against your query object and return the number of rows. I'm still not sure of a better way to do it from the XML document, but if anyone has any ideas, please email me.