On Sun, Jun 26, 2016 at 5:17 PM, Andy A <[email protected]> wrote:
> I would like to store chat conversation history (millions of messages) in > influxdb. > > I would like to know a few things > 1. Would that be a good usecase for influxdb? > Right now I wouldn't recommend this use case for InfluxDB. InfluxDB is optimized for numeric data, and has no string manipulation functions. > 2. Are there any provisions to search the conversation history in a > performant manner? (any benchmarks would be helpful) > Tag values can be searched via regex in a performant manner, but with each line being globally unique, more or less, that would lead to unsustainable cardinality for the tag index. Conversely, storing the chat as fields would have no index impact, but it would be impossible to search via regex. > 3. Finally, could I use influxdb as a datasource for elasticsearch without > having redundant data storage in both influxdb and elasticsearch? > Given InfluxDB's lack of string functions (other than COUNT()), I suspect it makes a poor datastore for elasticsearch. > I could just use elasticsearch but I would rather use a single datastore > instead of two different datastores. I have another usecase where I use > influxdb to store metrics and events data as well. > > -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to the Google Groups > "InfluxDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit > https://groups.google.com/d/msgid/influxdb/d31d9f43-3c40-4254-97c8-33e2f3813f5e%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/d31d9f43-3c40-4254-97c8-33e2f3813f5e%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvPGZqW-rjPLHfLaJUDnXT0kNAcce-RU-qp3%3Domv6t9sTw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
