Hi My test influxdb (v1.0.0) has 710745 recorders in the measurement. I try to get the last record. But the last recorder is working extremely slow.
Is there any suggestion how to quick get the last recorder? Running status: select count(glasses) from "eventlog" (takes about 12s ) ### qid query database duration 31"SELECT last(glasses), machine, status, chambers, content, type, chamberID FROM eventlog""icmcc""6m6s" 43"SHOW QUERIES""icmcc""1655266u" ### This is my simple select, it already used 6 Mins, and has not finished. My test environment: CPU: I7 3770 RAM: 16G. ubuntu server 16 Lee -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" 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/CAO31Sf5EE_0%2BkVoqC8C1qn8BwtrtarpgSuVY-THFXAL%3DPYkMKQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
