1 Reply Latest reply on Oct 12, 2009 1:27 PM by alwu-Oracle

    SDO_RDF_MATCH() Query Performace on 10g -> ontology model size-5000 triples

    617912
      Hi,

      We are observing severe degradation in the performance of the queries as their size increases? In this context, I want to know if the performance of the query is dependent on the query pattern size? For example, a query with 25 triples in the query pattern is taking nearly 10 secs, to retrieve results from a ontology of size 5000 triples. (no rule bases attached, no inferencing).

      Does using query API in Jena Adapter (instead of using sdo_rdf_match() directly) help improve the performance? Also, can u suggest any tuning on the ontology model for speeding up the query execution?

      Thanks,
      Rajesh.

      Edited by: rajesh narni on Oct 8, 2009 4:29 AM