user1083320
user1083320

Reputation: 1946

What database to use for large files

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

Answers (3)

Pekka
Pekka

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

HJW
HJW

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

Iljaas
Iljaas

Reputation: 520

Just a 180 rows a day should be absolutely no problem.

Upvotes: 1

Related Questions