Thank you for your reply!
What I want to know is that the data volume of this table is not
massive. If the logic of CQL cannot be modified, just inside Cassandra,
are there any parameters that can affect the behavior of this query? For
example, the fetchSize parameter of other databases?
在 2022/4/26 21:18, Dor Laor 写道:
select * reads all of the data from the cluster, obviously it would be
bad if you'll
run a single query and expect it to return 'fast'. The best way is to
divide the data
set into chunks which will be selected by the range ownership per
node, so you'll
be able to query in parallel the entire cluster and maximize the
parallelism.
If needed, I can provide an example for this
On Tue, Apr 26, 2022 at 3:48 PM 18624049226 <18624049...@163.com> wrote:
We have a business scenario. We must execute the following statement:
select * from tbl;
This CQL has no WHERE condition.
What I want to ask is that if the data in this table is more than
one million or more, what methods or parameters can improve the
performance of this CQL?
