[
https://issues.apache.org/jira/browse/SOLR-10038?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15849982#comment-15849982
]
samur araujo commented on SOLR-10038:
-------------------------------------
David, I have 6 millions points in Netherlands and I trying to query them using
the NL official polygon.
I did all optimizations you suggested to retrieve them all (precisely).
I paginate the results using 100K as query limit together with nextCursorMark.
I tried other limits but this one is the fastest. I am using solr locally, 8
cores, SSD and 4G allocated to it.
It takes ~400ms for each page. Is it a good time for solr ? is it possible to
do better than this without cluster?
> Spatial Intersect Very Slow For Large Polygon and Large Index
> -------------------------------------------------------------
>
> Key: SOLR-10038
> URL: https://issues.apache.org/jira/browse/SOLR-10038
> Project: Solr
> Issue Type: Improvement
> Security Level: Public(Default Security Level. Issues are Public)
> Components: spatial
> Affects Versions: 6.4
> Environment: Linux Ubuntu + Solr 6.4.0
> Reporter: samur araujo
> Assignee: David Smiley
> Labels: spatialsearch
>
> Hi all, I have indexed the entire geonames points (lat/long) with JTS
> enabled, and I am trying return all points (geonameids) within a certain
> polygon (e.g. Netherlands country polygon). This query takes 3 minutes to
> return only 10.000 points. I am using only solr intersect. no facets. no
> extra fitering.
> Is there any configuration that could slow down such a query to less than 300
> ms?
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
