6 Replies Latest reply on Aug 20, 2010 6:21 PM by 784525

    Query against Joseki generating tons of SELECTs

      Hi, I'm running Joseki on Tomcat with the latest sdordf/sdordfclient jars. It's configured to hit my my Oracle setup (described in [this thread|http://forums.oracle.com/forums/thread.jspa?threadID=1106143&tstart=0]) and things mostly work. I can query it without problem most of the time, however running the query I've included below results in nearly 8000 SELECT statements being issued. Eventually the query returns successfully, this just seems unecessary.

      The log file of a single session recording only the below query can be found here.

      PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
      PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
      PREFIX bsbm: <http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/>

      SELECT DISTINCT ?product ?productLabel
      WHERE {
      ?product rdfs:label ?productLabel .
      FILTER (<http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromProducer40/Product1828> != ?product)

      <http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromProducer40/Product1828> bsbm:productFeature ?prodFeature .
      ?product bsbm:productFeature ?prodFeature .
      <http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromProducer40/Product1828> bsbm:productPropertyNumeric1 ?origProperty1 .
      ?product bsbm:productPropertyNumeric1 ?simProperty1 .
      FILTER (?simProperty1 < (?origProperty1 + 120) && ?simProperty1 > (?origProperty1 - 120))

      <http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromProducer40/Product1828> bsbm:productPropertyNumeric2 ?origProperty2 .
      ?product bsbm:productPropertyNumeric2 ?simProperty2 .
      FILTER (?simProperty2 < (?origProperty2 + 170) && ?simProperty2 > (?origProperty2 - 170))
      ORDER BY ?productLabel
      LIMIT 5