-
Notifications
You must be signed in to change notification settings - Fork 4.1k
ui: initial load of table list takes minutes (!) when there are 10000+ tables in db #94332
Copy link
Copy link
Closed
Closed
Copy link
Labels
A-sql-observabilityRelated to observability of the SQL layerRelated to observability of the SQL layerA-webui-databasesA-webui-scalingC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.
Description
(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
- start
cockroach demowith the changes from sql: new functionscrdb_internal.generate_test_objectsand.gen_rand_ident#94027 - generate 10000 tables, e.g. via
select crdb_internal.generate_test_objects('{"counts":[10000],"name_gen":{"noise":false}}'::jsonb); - 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
Environment:
mastertowards v23.1
Epic: CRDB-20388
Jira issue: CRDB-22835
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-sql-observabilityRelated to observability of the SQL layerRelated to observability of the SQL layerA-webui-databasesA-webui-scalingC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.
