[ https://issues.apache.org/jira/browse/JENA-1277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15834501#comment-15834501 ]
Osma Suominen commented on JENA-1277: ------------------------------------- I've merged the PR with the fix. [~samuraraujo-geophy] Can you please verify that it helped? I'm leaving this JIRA issue open since it's not entirely clear to me whether the original problem was resolved. See my above comment for some unanswered questions. > 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 > Assignee: Osma Suominen > Attachments: spatial-assembler.ttl > > > 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)