I need to log actions in a web application to a simple table in a database. This database will become big after some time, because there will be inserted approx. 1000-2000 entries pr. day.
What database is best suited for such a purpose?
(I once did this with MySQL, but I think select'ing became quite slow, when the database grew big)
2000 entries per day is only seven million per decade
not a big table at all
if SELECTing became slow, you probably didn't index your table properly