New to the community? Start here

Multi-DB: Add field to New DB or 4096

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?

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.

Thanks in advance for your patience.

Best,

Kevin

Mon, 28 Apr 2008 14:37:51
  • drmike
    • DEV MAN’s Mascot

    Actually for 1000 blogs, I would have only done 16 databases. You now have more databases than you have blogs. :slight_smile:

    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.

  • Andrew
    • Champion of Loops
      Actually for 1000 blogs, I would have only done 16 databases. You now have more databases than you have blogs. :slight_smile:

    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