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?
On Tue, Aug 23, 2016 at 2:16 PM, Emiliano Heyns < [email protected]> wrote: > On Tue, Aug 23, 2016 at 10:02 PM, Sean Beckett <[email protected]> wrote: > >> >> >> COUNT() is valid, but you are comparing the number of points in one >> database vs. the number of points written to the entire instance. If you >> run SHOW DATABASES you can see what other databases are on the system and >> contributing to the pointReq number. >> > > Aha, that's what you meant. The shard info includes all data, also of the > internal administration, and because of the every 10s thing, it'll always > grow. And I can't really split it out per database. Correct? > > Is this something that could be reasonably be done by an continuous query? > The count(*) takes about 12 secs, it's OK if it's a little behind, but I'd > rather not have the monitoring UI hang for 12 secs when the user requests > the value. > > -- > 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/CAHOSGO5i9dF4B5PVYaVzU4EHP_ah26x2xD8U2%2B99OUO753oG_w% > 40mail.gmail.com > <https://groups.google.com/d/msgid/influxdb/CAHOSGO5i9dF4B5PVYaVzU4EHP_ah26x2xD8U2%2B99OUO753oG_w%40mail.gmail.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/CALGqCvMKHLR8cqQ11tJ%2BK18yZT5fvmvidYGaJDCtD%3DXYf2246w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
