here is tutorial about multi index/type search:
as to how to organize your data, it is really hard to say
it all depends of the size of your databases and the type of documents you
want to index, from the top of my head:
- if your documents are hierarchically related (parent-child) then they
have to go to this same index
- if you run your queries only against subset of tables (different query
different subset), then consider grouping them into different indexes (or
- if you run your query always against all tables, then you can even put
everything in one index with many shards (as there is really no much
difference between running query on one index with multiple shards and
running query on multiple indexes)
check this articles as starting point to learn more:
On Friday, December 27, 2013 10:22:04 PM UTC, jsp wrote:
I have recently started playing with ES for a site search project. My
search query runs against multiple tables across two databases, masterDb &
clientDb. So my plan is to create two indexes one for each database and
then add multiple types to each index.
And then finally query across those indexes for result.
Can anyone comment is this approach correct? And secondly how can i query
across indexes & types that I have created to get my results back? Any link
to a tutorial would be great
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to email@example.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/bb2ac8e0-bcdc-4754-9eed-1fb422932ba7%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.