Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Investigate possible performance bug with limit 1 queries with where clause #821

Closed
wants to merge 1 commit into from

Conversation

toddboom
Copy link
Contributor

This blog post: http://www.ryandaigle.com/a/time-series-db-design-with-influx mentions getting a performance increase on a query like this:

select value
  from gateway.account.sample
  where account_key = 'abc123'
  limit 1

-- and this gives same result, but much better performance
select value
  from gateway.account.sample
  where time > now() - 2d
    and account_key = 'abc123'
  limit 1

This is on a series that has hundreds of thousands of points. This looks to me like the range scan is still going through after the limit has already been hit.

We need to look into this and ensure that once the limit is hit, the scan stops.

@Dieterbe Dieterbe mentioned this pull request Sep 10, 2014
@toddboom toddboom self-assigned this Oct 23, 2014
@toddboom
Copy link
Contributor

@jvshahid can you give this a look?

@toddboom toddboom closed this in 6eb6e6a Oct 27, 2014
@toddboom toddboom removed the review label Oct 27, 2014
@toddboom toddboom deleted the fix-821-limit-queries branch May 5, 2015 19:44
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants