Skip to content
TrackPodcasts
technologyApr 3, 202121:16pending

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

About this episode

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

Get every episode summarized

Each time The Backend Engineering Show with Hussein Nasser publishes, we email you a written briefing from the transcript — the topics, who appeared, and any specific claims, with the ad reads skipped.

Email me new episodes

Free for 3 shows. No card needed.

Hosts & guests

No transcript yet

This episode has not been transcribed. Request it and it moves to the front of the queue.

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

The Backend Engineering Show with Hussein Nasser

0:00
21:16

More episodes

More from The Backend Engineering Show with Hussein Nasser

View all episodes →