Re: Ever growing database tables – is this normal?
Yep, completely normal and its actually a good way to scale a site.
You could then install one the few multiple db plugins like hyper DB so you can then buy another server and spread the load. OR you could just run it on the same server if you don\’t have the requirements for more processing power as if you split into chunks using hyperdb it does make it easier to manage.
Think of it like this, 2 million rows in 1 DB or 200,000 rows spread over 10 db\’s.
If you\’ve ever tried to manage a DB with 2million rows which is kinda modest in the grand scale, you will need a pretty decent server, but you could run 200k rows on a celeron with 1 gig of ram!