Ever growing database tables – is this normal?
-
Alright, I’m a dumba$$ when it comes to databases. But I observed on my local install of WPMU+BUDDYPRESS (using XAMPP) that every time I see new tables being created under the wordpress database.
For example, I see following tables being generated every time there is some user activity:
wp_user_1_activity
wp_user_1_activity_cached
.
.
.
and so on.
Is this normal? My database is supposed to be 9,000 members (to start with) , so will this cause a problem in future?
-
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!
Cool
. I have used vBulletin before. They use some different technique I guess. It runs pretty well too.
- The topic ‘Ever growing database tables – is this normal?’ is closed to new replies.
