2 points
Community rank #11486
mylocalcause
NewbieJust Getting Started
MemberLikes (0)
Hi,
This is my first stupid question (to this site). I searched for answers to this, but must admit that I am a WPMU newbie fighting for a clue and may have overlooked answers or common sense.
Question: should I simply create a single database of a few text fields that each blog will have a record in or attempt to add text fields to the 4096 DB?
What are the performance tradeoffs? [Right now, few blogs (alpha testing), but I plan to have 1000+]
Or does the insanity of modifying and possibly breaking 4096 DB outweigh any possible performance?
Andrew and James at incSub installed 4096 DB for me. So, I'm trying not to mess that up since it works.
[mylocalcause.com is a blogsite where users raise funds and awareness for their favorite non-profit or cause.] I'm looking to add a new text fields "cause name" and "cause address" to document the name and address of each blog's designated cause for commissions to be sent.
Right now, I'm just using the existing $blogdescription field to capture this information.
For functionality, want users to be able to select from causes already entered from other users.
6593 pointsCommunity rank #9Supreme DeityMember of the MonthLifetime member
Keeper of the Dark Chocolate
(joined July 2007)
Likes (0)
Actually for 1000 blogs, I would have only done 16 databases. You now have more databases than you have blogs. :)
To be honest, I would just save these extra text fields as options within each blog's already created databases. That's how the software stores text fields already like the blog title and subtitles. Also you wouldn't have to do any major reworking of the code as you would be using the get_option, add_option, and edit_option function calls to work with that data.
7430 pointsCommunity rank #6Supreme DeityMember of the MonthLifetime member
Erstwhile founder
(joined May 2007)
Likes (0)
Actually for 1000 blogs, I would have only done 16 databases. You now have more databases than you have blogs. :)
We usually setup clients who plan on growing over the years with 4096 right off the bat if they have dedicated hardware. It's a pain to switch over later on.
Question: should I simply create a single database of a few text fields that each blog will have a record in or attempt to add text fields to the 4096 DB?
I'd just create a new table in the global db. One table with just that little bit of info isn't going to hurt anything.
Responses (6)
Keeper of the Dark Chocolate (joined July 2007) Likes (0)
Actually for 1000 blogs, I would have only done 16 databases. You now have more databases than you have blogs. :)
To be honest, I would just save these extra text fields as options within each blog's already created databases. That's how the software stores text fields already like the blog title and subtitles. Also you wouldn't have to do any major reworking of the code as you would be using the get_option, add_option, and edit_option function calls to work with that data.
Erstwhile founder (joined May 2007) Likes (0)
Actually for 1000 blogs, I would have only done 16 databases. You now have more databases than you have blogs. :)
We usually setup clients who plan on growing over the years with 4096 right off the bat if they have dedicated hardware. It's a pain to switch over later on.
Question: should I simply create a single database of a few text fields that each blog will have a record in or attempt to add text fields to the 4096 DB?
I'd just create a new table in the global db. One table with just that little bit of info isn't going to hurt anything.
Thanks,
Andrew
Member (joined July 2007) Likes (0)
To add a note for folks who may come across the thread at a later date:
Don't even try to use this plugin on shared hosting.
Keeper of the Dark Chocolate (joined July 2007) Likes (0)
Why not? All my installs except for the big one are on shared hosting accounts.
Although I don't overload my boxes like most hosts do.
Member (joined July 2007) Likes (0)
Your situation with that is completely different, and you know it. :P
Keeper of the Dark Chocolate (joined July 2007) Likes (0)
I must be special. :)
Become a member