3 Replies Latest reply on Nov 23, 2010 3:38 AM by Sdas-Oracle

    Observing poor performance on the execution of the quereis

    817559
      I am executing a relatively simple query which is rougly taking about 48-50 seconds to execute. Can someone suggest an alternate way to query the semantic model where we can achieve response time of a second or under. Here is the query

      PREFIX bp:<http://www.biopax.org/release/biopax-level3.owl#>
      PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>
      PREFIX ORACLE_SEM_FS_NS:<http://oracle.com/semtech#dop=24,RESULT_CACHE,leading(t0,t1,t2)>
      SELECT distinct ?entityId ?predicate ?object
      WHERE
      {
      {
      ?entityId rdf:type bp:Gene .
      ?entityId bp:name ?x .
      ?entityId bp:displayName ?y .
      ?entityId ?predicate ?object .
      FILTER(regex(?x, "GB035698", "i")||regex(?y, "GB035698", "i"))
      }
      }

      Same query executed from sqldeveloper takes about as long as well

      SELECT distinct /*+ parallel(24) */subject,p,o
      FROM TABLE
      (sem_match ( '{?subject rdf:type bp:Gene .
      ?subject bp:name ?x .
      ?subject bp:displayName ?y .
      ?subject ?p ?o
      filter (regex(?x, "GB035698", "i")||regex(?y, "GB035698", "i") )
      }',
      sem_models ('biopek'),
      null,
      sem_aliases
      ( sem_alias
      ('bp',
      'http://www.biopax.org/release/biopax-level3.owl#'
      )
      ),
      NULL,
      null,null ))

      Is there anything I am missing, can we do anything to optimize our data retrieval?

      Best Regards,

      Ami