# What are the main tradeoffs when switching to ScyllaDB?

<p class="elv-tracking-normal elv-text-default elv-font-figtree elv-text-base elv-leading-base elv-font-normal" elv="true"><strong>What are the main tradeoffs when switching to ScyllaDB?</strong></p>

##### Post Metadata
- Posted at: 4 months ago
- Net upvotes: 1


## Comments
### Comment 1

As a NoSQL database, ScyllaDB prioritizes performance and scalability over traditional relational features like complex joins or ad-hoc reporting. While it supports linearizable, single-partition transactions through Paxos and Raft, it does not currently support full ACID transactions spanning multiple tables or partitions. Users should also invest time in proper data modeling to ensure data is partitioned correctly, as poor modeling can lead to “hot shards” that degrade performance.

##### Comment Metadata
- Posted at: 4 months ago
- Author title: Technical Director




## Related Product
[ScyllaDB](https://www.g2.com/products/scylladb/reviews)

## Related Category
[Key Value Databases](https://www.g2.com/categories/key-value-databases)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4