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

[YCQL/YSQL] Select scans for more rows than necessary, slowing down performance #13885

Open
lnguyen-yugabyte opened this issue Sep 6, 2022 · 0 comments
Open

[YCQL/YSQL] Select scans for more rows than necessary, slowing down performance #13885

lnguyen-yugabyte opened this issue Sep 6, 2022 · 0 comments
Assignees
@sushantrmishra
Labels
area/ycql Yugabyte CQL (YCQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue

Comments

@lnguyen-yugabyte
Copy link
Contributor

lnguyen-yugabyte commented Sep 6, 2022 •
edited by kmuthukk
Loading

Jira Link: DB-3384

Description

Test Case:
YCQL: https://gist.github.com/kmuthukk/bd5ebf6dcbecc61b2647c47718ddcdfb

YSQL: https://gist.github.com/kmuthukk/3d69f87d49d9dca32b181008f31493a8

In some cases, scan does not early terminate even when the number of rows in the limit clause has been reached.
@lnguyen-yugabyte lnguyen-yugabyte added area/ycql Yugabyte CQL (YCQL) status/awaiting-triage Issue awaiting triage labels Sep 6, 2022
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Sep 6, 2022
@kmuthukk kmuthukk changed the title [YCQL] Select scans for more rows than necessary, slowing down performances [YCQL] Select scans for more rows than necessary, slowing down performance Sep 6, 2022
@yugabyte-ci yugabyte-ci removed the status/awaiting-triage Issue awaiting triage label Sep 6, 2022
@kmuthukk kmuthukk changed the title [YCQL] Select scans for more rows than necessary, slowing down performance [YCQL/YSQL] Select scans for more rows than necessary, slowing down performance Sep 8, 2022
@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature and removed kind/bug This issue is a bug labels Sep 12, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@sushantrmishra sushantrmishra

Labels
area/ycql Yugabyte CQL (YCQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@sushantrmishra @yugabyte-ci @lnguyen-yugabyte