[
https://issues.apache.org/jira/browse/JENA-1277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15827616#comment-15827616
]
samur araujo commented on JENA-1277:
------------------------------------
Hi Osma, I guess you saw my assembler attacked to jira. This is all
configuration I have.
I glad to hear that you identify the error. Do you have the actual queries that
is being issued to the index (for example a solr query)? That you allow me to
help to debut the solr index directly. I think it is strange that a sorting
takes so long.
Another observation is that the limit in the spatial query does not seem to
reflect the limit in the sparql query. If the limit is set to 10000 as default
but the spatial query could return 20000, the final sparql query will have
incomplete results. Would make sense to set the solr index according to sparql
limit or the default fuseki limit ?
> 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)
