New to search stuff doing some research looking at either ES or Solr.
Lets say I want to create an address database to verify addresses with
street name, city, zipcode etc. worldwide.
Each of these fields needs to be searchable. For example you can
search on zipcode to bring up all cities, or vice versa.
I also want to separate the countries so I dont need to search through
the US database when looking up UK address. This concept is easy to
grasp in mySQL etc. By defining country=US ... but in ES will US be
one index? Or will all the streets, city, zipcode + US be one index
How many indexes do you need and how do you count this? And can you
separate databases like this to avoid unnecessary searching?
If the database before import has 50 million rows, how many records
will this end up in ES if each row for example contains street name,
city, zipcode (in theory)?
Do you think ES could search 50 million records/rows under 0.5
seconds? Maybe in a cloud environment? Or do you need a really big
cluster for this?
Any input appreciated.