What are the queries, what is the speed of queries? A growing number of shards is not related to speed, it is are related to scalability. This means, even with large document count, the search response time can be kept low by creating indices that span multiple nodes. If you increase number of replica shards, you can serve more searches in parallel.
ES can not replace MySQL, because ES is not a relational database system. ES is faster than MySQL's direct index because ES queries can operate in-memory. If you do not want inverted index, choose doc values. Jörg On Mon, Mar 2, 2015 at 8:54 AM, Zhantong Mou <[email protected]> wrote: > I have one billion data in mysql. the data of mysql is like name, ID > cards, phone numbers. They are almost unique. > Whether the ElasticSearch based on Inverted index can ensure the speed of > queries? > Can we justify the numbers of shards improves the speed of the query? > If ES can replace MySql, how ES ensures the performance? I think the > structured > data can not have good performance than Mysql, because that it based on > Inverted > index. > > -- > 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 protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/e61eb6fb-3f5a-40fc-974d-283d76030821%40googlegroups.com > <https://groups.google.com/d/msgid/elasticsearch/e61eb6fb-3f5a-40fc-974d-283d76030821%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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 protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoHxg_cpaZc06F9G_VD_vvB7LP-7pDsqef9sAHcoeOBW5w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
