Skip to content

cockroachdb cli client is slower than.. itself #54679

@kocoten1992

Description

@kocoten1992

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.O-communityOriginated from the community

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions