-
Notifications
You must be signed in to change notification settings - Fork 4.1k
cockroachdb cli client is slower than.. itself #54679
Copy link
Copy link
Labels
C-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.O-communityOriginated from the communityOriginated from the community
Description
Describe the problem
cockroachdb cli client display result slower than it should, for example:
To Reproduce
user@computer:~$ time cockroach sql --insecure -e 'select 1'
?column?
------------
1
(1 row)
Time: 1.135871ms
real 0m0.088s
user 0m0.110s
sys 0m0.013s
Nothing to complain about, it extremely fast.
And yet here:
user@computer ~ cockroach sql --insecure
#
# Welcome to the CockroachDB SQL shell.
# All statements must be terminated by a semicolon.
# To exit, type: \q.
...
root@:26257/defaultdb> select 1;
?column?
------------
1
(1 row)
Time: 473.328µs
It said 473.328µs but I'm pretty sure it take almost a second to display result, for someone who use sql client all the time, that 1 second addition to every query isn't pleasure to work with.
Environment:
- CockroachDB version
v20.2.0-alpha.3(it doesn't matter, it there since very long time) - Server OS:
ubuntu - Client app
cockroach sql
Additional context
What was the impact?
Not very refreshing experience when using cockroachdb client.
Jira issue: CRDB-3728
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-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.O-communityOriginated from the communityOriginated from the community