Another question for Database-Gurus:

Is a MySQL table with 4 columns and about 42000+ rows considered 'big' or should the table be split in smaller pieces?

.

You should start counting in Millions...

//

I'm by no means a database guru but in my experience you can store millions of rows in such a table without any performance issues given that there is a primary index. The real performance hogs will be your queries if they are inefficiently written 😉

That’s a small table.