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

ui: initial load of table list takes minutes (!) when there are 10000+ tables in DB #94331

Closed
knz opened this issue Dec 27, 2022 · 1 comment
Closed
Labels
A-sql-observability Related to observability of the SQL layer A-webui-databases A-webui-scaling C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.

Comments

@knz
Copy link
Contributor

knz commented Dec 27, 2022

(Found via #94027)

Describe the problem

When there are 10000+ tables in a single db, the initial display of the table list takes 30+ seconds, leaving the user to wonder if something is broken.

To Reproduce

  1. start cockroach demo with the changes from sql: new functions crdb_internal.generate_test_objects and .gen_rand_ident #94027
  2. generate 10000 tables, e.g. via select crdb_internal.generate_test_objects('{"counts":[10000],"name_gen":{"noise":false}}'::jsonb);
  3. navigate to db console -> defaultdb eg. via http://127.0.0.1:8080/#/database/defaultdb

Observe: the page remains blank for very long.

Expected behavior

The first page of results should display immediately.

Additional data / screenshots

image

Environment:

  • master towards v23.1

Jira issue: CRDB-22834

@knz knz added C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. A-webui-databases A-webui-scaling A-sql-observability Related to observability of the SQL layer T-sql-observability labels Dec 27, 2022
@knz
Copy link
Contributor Author

knz commented Dec 27, 2022

dup #94332.

@knz knz closed this as completed Dec 27, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-sql-observability Related to observability of the SQL layer A-webui-databases A-webui-scaling C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.
Projects
None yet
Development

No branches or pull requests

1 participant