LIMIT does not yet restrict the number of points queried, only the number of points returned. Add a "WHERE time" clause to prevent the query from sampling all points in the measurement.
On Wed, Oct 5, 2016 at 4:04 AM, <[email protected]> wrote: > > I have stored around 4 crore records in a measurement. when i tried to to > look into only 4 records using a select query, it is taking whole memory > and result into my system get hanged. > > query i used is : select * from new_fuelitems limit 5 > > Can anyone help me on this. > > -- > 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/b66c09d2-5e91-4de1-bad6-775a8b29e49a%40googlegroups.com. > 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/CALGqCvOzKzSsqnT%2BCkSrK091e5f%2B2B2WBddV4E%3D0NCF%3DZZWdBg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
