samur araujo created JENA-1277:
----------------------------------

             Summary: Spatial Queries Very Slow For Large Databases
                 Key: JENA-1277
                 URL: https://issues.apache.org/jira/browse/JENA-1277
             Project: Apache Jena
          Issue Type: Improvement
          Components: Spatial
    Affects Versions: Jena 3.1.1
         Environment: Linux Ubuntu
            Reporter: samur araujo


I loaded geonames on Jena but the spatial queries take more than 3s to execute. 
The query is below:

PREFIX spatial: <http://jena.apache.org/spatial#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT distinct ?place
{
    ?place spatial:intersectBox (32.55668 -117.12865 32.56668  -117.13865) .
  
}

The data can be downloaded here:
https://drive.google.com/file/d/0B-fwYPJYT1GOYVVIZF9ROUxzclk/view?usp=sharing

For small datasets the queries are executed in 200ms, very fast. I noticed that 
when I access the lucene index directly the queries are also very fast, about 
20ms. 

The issue may be related to the pos-processing of lucene results.





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to