My Python CRUD App hit 2 Million Rows, Should I Shard My Database?

I have a 2 million row table used in my CRUD Python app, I’m worried that as the table grows my inserts will slow down, should I consider sharding my database or partition the table?

Someone asked a question on Twitter and I thought it's interesting to answer it here in the show.

I have a 2 million row table used in my CRUD python app, I’m worried that as the table grows my inserts will slow down, should I consider sharding my database or partition the table? thank you

• 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 as microservices day 1 scares me

python database

This video on 'Python Database Connection', you will learn how to establish a connection between Python and MySQL DB and perform CRUD operations on it.

In this tutorial, you’re going to learn a variety of Python tricks that you can use to write your Python code in a more readable and efficient way like a pro.

Today you're going to learn how to use Python programming in a way that can ultimately save a lot of space on your drive by removing all the duplicates. We gonna use Python OS remove( ) method to remove the duplicates on our drive. Well, that's simple you just call remove ( ) with a parameter of the name of the file you wanna remove done.

In the programming world, Data types play an important role. Each Variable is stored in different data types and responsible for various functions. Python had two different objects, and They are mutable and immutable objects.

Magic Methods are the special methods which gives us the ability to access built in syntactical features such as ‘<’, ‘>’, ‘==’, ‘+’ etc.. You must have worked with such methods without knowing them to be as magic methods. Magic methods can be identified with their names which start with __ and ends with __ like __init__, __call__, __str__ etc. These methods are also called Dunder Methods, because of their name starting and ending with Double Underscore (Dunder).