You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cassandra.apache.org by Inquistive allen <in...@gmail.com> on 2019/10/11 14:20:31 UTC

Select statement in batch

Hello Team,

Wanted to understand the impacted of using a select statement inside a
batch.
I keep seeing some slow queries frequently in the logs.

Please comment on what may the impact of the same. Is it the right
practice. Will a select statement in batch be lead to increase in read
latency than a normal select prepared statement.

Thanks,
Allen

Re: Select statement in batch

Posted by Hossein Ghiyasi Mehr <gh...@gmail.com>.

Hello,
Batch isn't for selet only query, it's for transactional queries. If you
want to read data, you should use select query (prepared or simple or etc.)

On Fri, Oct 11, 2019 at 5:50 PM Inquistive allen <in...@gmail.com>
wrote:

> Hello Team,
>
> Wanted to understand the impacted of using a select statement inside a
> batch.
> I keep seeing some slow queries frequently in the logs.
>
> Please comment on what may the impact of the same. Is it the right
> practice. Will a select statement in batch be lead to increase in read
> latency than a normal select prepared statement.
>
> Thanks,
> Allen
>