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

Yugabyte query redesign #1777

Open

LexLuthr opened this issue Oct 25, 2023 · 1 comment

Collaborator

LexLuthr commented Oct 25, 2023

To alleviate stress from multiple Count() queries, we need to recheck our code base.

Benchmark the current times
Ask large SPs to benchmark
Check if we can get rid if Count queries
Create covering indexes for PieceDeal if required (it would double up the space required by the table)

github-project-automation bot added this to Boost

LexLuthr added this to the Boost v2 stability milestone

Collaborator

davidd8 commented Oct 25, 2023

What is the actual "stress" being caused, too many queries, are the Count() queries taking too long, are the tables not indexed properly?

brendalee removed this from the Boost v2 stability milestone

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment