Hello, I have a question related to data/application design .
I want to use elasticsearch to get some statistics , we currently use MySQL but we have serious performance issues , i really think ES can help us. I have a table that record some event of operators login and logout . It looks like this ID I operator I event I datetime ---------------------------------------------- 12 I 4587 I login I 2014-01-20 10:15:10 12 I 4581 I login I 2014-01-20 12:15:10 12 I 4587 I logout I 2014-01-20 13:15:10 from this i need to provide some stats like for exemple : for a given day/week/month how much time do have a least 1 operator online for a given day/week/month how much operator are online at the same time then i need for exemple a granularity hour per hour i currently fetch some data from mysql and compute my stats using php , but we talk here about millions of entries i and i expect to get much more in few months , so i need something fast . So my questions are , does ES can be usefull if i store my data as it , does ES provide the necessary tools to make some stats without having to compute after fetching the datas . Do i have to compute some data before storing in ES ( for exemple calculate for each hour of the day and store each hour as a document ) i would love to hear from you if you already have such a case , or if you have some ideas . ( if it's not the good place for such a discussion where can i post it ? ) Thanks -- 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/e01aa314-3d1f-4286-9283-0b3f22b7b171%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
