[SERVER-2979] Improve haystack search with multi-criteria, multi-key, and multi-location support. Created: 21/Apr/11  Updated: 28/Dec/23

Status: Backlog
Project: Core Server
Component/s: Geo
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Greg Studer Assignee: Backlog - Query Integration
Resolution: Unresolved Votes: 5
Labels: qi-geo
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Integration
Participants:

 Description   

Haystack supports fast 2d+criteria searches, but right now is limited in terms of the way the criteria can be specified, and to a single additional field. Also is not integrated with general query optimizer/planner. May be worth enhancing along with more general pluggable index type enhancements.

User case is basically all users who want to do fast "find all restaurants that serve thai food 10 blocks from NYU" searches with large data sets.



 Comments   
Comment by Robert Stewart [ 30/Apr/13 ]

Being able to use more than one additional field in the index would likely be very helpful to me. I have two fields that I always need to filter on in addition to the location. I chose the one that provided more selectivity, but on the application side I still sometimes have to iterate through thousands of results, often filtering out more than half of them.

Comment by Chris Eppstein [ 22/Apr/11 ]

I'd also point out that this index is currently intolerant of properties set to null – the other geo indexes handle that case just fine.

I'd like to use this feature, but without at least the ability to index and query on additional fields, it's not viable for us. It would be nice if the query planner could take advantage of this, but that's a nice-to-have in my opinion.

Generated at Thu Feb 08 03:01:44 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.