Re:Search Benchmarking: RediSearch vs. Elasticsearch
by sandGorgon on Sunday April 21, 2019 @05:38AM
(#19711336)
Do you do left outer join on elasticsearch...or do you do it in the client code ? I'm trying to figure out if elasticsearch supports these query types. It's something I never thought about.
Re:Search Benchmarking: RediSearch vs. Elasticsearch
by atombender on Sunday April 21, 2019 @09:43AM
(#19712040)
In client code. ES doesn't do joins (ignoring a rather weak feature called "nested documents").
Where ES is not optimal is when you need joins. That said, doing left outer joins -- which is typical in web workloads where you may have something like an "articles" table that you want to query with filters and then join against "authors" and "categories" without filters to fetch connected data -- on the client side with some basic parallelization is surprisingly effective. Currently doing that in some apps where we get <100 millisecond performance even when fetching maybe 5-6 related objects per result.