Originally from the User Slack
@raghav_tandon: Hi, have a small question…
If i have a partition with key/value pair and partition size will never go beyond 200kB.
So, if i do IN query (for specific partition) to fetch only some keys would that be beneficial or scylla will always fetch entire partition and we will only save on network.
@avi: It will likely fetch the entire partition, but you can check with tracing
@raghav_tandon: so we have a design decision to make like a blob with a everything in one column or as a key/value store… if entire partition is fetched then both would give same performance?
@avi: It’s generally better to have separate rows/columns rather than blobs (esp if they’re modified separately)
@raghav_tandon: sure, Thanks for the clarification