If using SELECT last(glasses), machine, status, chambers, content, type, chamberID FROM eventlog WHERE time > now() -7d ,
It will get the result quickly. (7s.) It seems, the last is iterate whole database and then get the result. Why the last() function could not find the final recorder without iterate whole records and than return? Lee On Wed, Oct 12, 2016 at 9:56 AM, yueyue papa <[email protected]> wrote: > 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/CAO31Sf604n%3D0z-YLgs9829FCj6GV96rqkROiZTrohKCd5QPu0w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
