Skip to content
My Python CRUD App hits 2 million rows, Should I Shard my Database? episode artwork

Apr 3, 2021 21 min

My Python CRUD App hits 2 million rows, Should I Shard my Database?

from The Backend Engineering Show with Hussein Nasser Hosted by Hussein Nasser

Hey Hussein I have a 2 million row table used in my CRUD python app, I’m worried that as the table grow my inserts will slow down, should I consider sharding my database or partition the table? thank you I’m avid of simplicity in design if I can do it in one machine I’ll do it. Sharding/Partitioning are all great inserts are fast, queries are slow 0:00 inserts can be slow 3:00 indexes/stored procedures selects, updates, and deletes can be slow 12:00 add proper indexes. simplicity wins, premature optimization is bad 15:20 crazy things that people say like microservices day 1 scares me

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

My Python CRUD App hits 2 million rows, Should I Shard my Database?

0:00 21:16

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of The Backend Engineering Show with Hussein Nasser?

This episode is 21 minutes long.

When was this The Backend Engineering Show with Hussein Nasser episode published?

This episode was published on April 3, 2021.

Can I download this The Backend Engineering Show with Hussein Nasser episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.