CODEWITHSUNDEEP
sql-serverdatabaseperformancescalingsharding
SDReyes
SDReyes

Reputation: 9954

How to scale writings in your DB without recurring to sharding?

How would you scale writings without recurring to sharding (specially with SQL Server 2008)?

Upvotes: 2

Views: 185

Answers (2)

Liran Zelkha
Liran Zelkha

Reputation: 129

Why not shard? The complexities in the code can be avoided by using transparent sharding tools, which ease all the heavy lifting associated with sharding. Check out ScaleBase for more info

Upvotes: 1

Manuel Salvadores
Manuel Salvadores

Reputation: 16525

Normally ... avoid indexes and foreign keys in big tables. Every insert/update on a indexed column implies rebuilding partially the index and sometimes this can be very costly. Of course, you'll have to trade query speed VS writing speed but this is a known issue in database design. You can combine this with a NoSQL database with a some sort of mechanism for caching queries. Maybe a fast NoSQL system sitting in front of your transactional system.

Another option is to use transactions in order to do many writes in one go, when you commit the transaction the indexes will be rebuilt but just once per transaction not one per write.

Upvotes: 2

Related Questions