Reputation: 1946
I have a table of just 4 columns. But everyday, about 180 new rows are added to the table. Is MySQL fast and efficient enough to handle this much data?
I have a cron job on this data that runs hourly.
Thanks!
Upvotes: 0
Views: 59
Reputation: 449813
But everyday, about 180 new rows are added to the table.
That is a laughably small amount of data for a database. Databases are designed to hold millions or even billions of records, and to operate at very high frequencies (like, many inserts per second). Don't worry about it.
Related: What is the maximum size of a MySQL database in version 5 and up?
Upvotes: 3
Reputation: 23453
On average a shared hosting server with just one instance of MySQL server running serves ~ 200 + Wordpress blogs, day after day.
Just a heads up.
Upvotes: 0