axonops / axonops-workbench

AxonOps™ Workbench for Apache Cassandra® - Desktop application for Mac, Windows and Linux
https://axonops.com
Apache License 2.0
10 stars 0 forks source link

[bug]: Selects from tables with lots of rows eg virtual table system_views.settings is signicantly slower than standard CQL console on responding #363

Closed millerjp closed 3 weeks ago

millerjp commented 3 weeks ago

Do I have the most recent version of AxonOps Workbench installed?

AxonOps Workbench Version

1.0.0-beta-20240905

Is there an existing issue for this?

Operating System

MacOS

Operating System Version

14.6.1

Apache Cassandra Version(s)

4.1.6

Bug Description

When you run the query select * from system_views.settings; in the enhanced CQL console, the app just sits there hanging waiting for a response to come, and its taking a long time compare to standard cql console

I think this could be a sympton of the table having ~ 500 rows i.e the enhanced console has a performance issue. As the basic CQL console comes back immediately.

Steps to Reproduce

Just run a the query in the enhanced console and the CQL console and see the results.

Expected Behavior

N/A

Actual Behavior

very very very slow

Severity

High

Further Information

No response

millerjp commented 3 weeks ago

Can also be tested with this attached example data perfbug.txt