See this comment on a LIMIT issue <https://github.com/influxdata/influxdb/issues/7182#issuecomment-241759256> for context on why the LAST() point in a series can be tough to define. With no tags included, the system has to look for the LAST() point in every possible series for that measurement. The time rage restricts the search space, making that faster.
On Tue, Oct 11, 2016 at 8:14 PM, yueyue papa <yueyuep...@gmail.com> wrote: > 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 <yueyuep...@gmail.com> 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 influxdb+unsubscr...@googlegroups.com. > To post to this group, send email to influxdb@googlegroups.com. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit https://groups.google.com/d/ms > gid/influxdb/CAO31Sf604n%3D0z-YLgs9829FCj6GV96rqkROiZTrohKCd > 5QPu0w%40mail.gmail.com > <https://groups.google.com/d/msgid/influxdb/CAO31Sf604n%3D0z-YLgs9829FCj6GV96rqkROiZTrohKCd5QPu0w%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 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 influxdb+unsubscr...@googlegroups.com. To post to this group, send email to influxdb@googlegroups.com. 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/CALGqCvMF1K8gvxhq_v8tE8dgjG%2BNSs726Q8u-4QnVwzVt8QqTg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
