On Tue, Aug 23, 2016 at 11:58 PM, Sean Beckett <[email protected]> wrote:
> It usually makes sense to use a CQ to pre-calculate expensive or very > common queries. However, CQs require a "GROUP BY time" clause. Are you > running COUNT() over intervals or since all time? > > Since all time, but if I can group by 315360000s, that's plenty. Actually, any time slice is OK, since summing over multiple rows will be plenty fast. I tried "select count(*) from car where time > 0 group by time(315360000s)", but that gives me 5 rows, and there's only 11 months of data in the DB. Loosely related, can I stick the results of SHOW STATS in a CQ? -- 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/CAHOSGO4gUPpdgYXbwQ_%2BPctEyN4AGcbavnucqHROtGHWusgLow%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
