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.

Sign up for GitHub

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

Jump to bottom

Conditionally Disable Count from Being Returned #13

Open
ksylvest opened this issue Aug 15, 2013 · 2 comments
Open

Conditionally Disable Count from Being Returned #13

ksylvest opened this issue Aug 15, 2013 · 2 comments

Comments

@ksylvest
Copy link
Contributor

For large tables including the count can have very large performance implications:

SELECT COUNT(id) FROM something; -- Runtime: 5507.556ms
SELECT * FROM something LIMIT 50 OFFSET 0; -- Runtime: 0.193 ms

It would be great to be able to send in an option to disable the count entirely.
@cantino
Copy link
Contributor

cantino commented Sep 17, 2013

Hey @ksylvest, I agree that this would make sense as an option. Is this something you'd like to try adding?

@ksylvest
Copy link
Contributor Author

@cantino Yeah, I can take a look.

@davbre davbre mentioned this issue Apr 19, 2015
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@ksylvest @cantino