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

Enhance YSQL sample apps to allow for variable number of columns #2802

Closed

bmatican opened this issue Oct 31, 2019 · 1 comment

Assignees

Labels

area/docdb kind/bug priority/medium

Contributor

bmatican commented Oct 31, 2019 •

edited by yugabyte-ci

Loading

Jira Link: DB-2226
We should allow for both:

varying the number of columns in the schema (setup wide tables)
varying the number of columns in the read requests (be able to run experiments on 1 large column read vs N smaller columns)

We can then use this to compare perf on

select of 1 column of 1000 bytes vs a select of 10 columns of 100 bytes each
select of K columns from tables of 10, 50, 100 columns

@spolitov already confirmed from #1877, that, for a given table, select times grow linearly with number of columns.

bmatican added the area/docdb label

bmatican assigned spolitov

bmatican assigned bmatican and unassigned spolitov

Contributor Author

bmatican commented Nov 15, 2019

@mbautin I think you had a sample-app PR that might be extendable to cover this too: yugabyte/yb-sample-apps#16

Is that something you'll try to get back to?

yugabyte-ci added kind/bug priority/medium labels

yugabyte-ci closed this as completed

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