[wp-hackers] State of WP

[Dr. Mike Wendell]

On 4/9/07, Donncha O Caoimh <donncha at linux.ie> wrote:
> Dr. Mike Wendell wrote:
> This has been explained several times on the MU forums, but for a quick
> recap, the simplest way to use multiple databases is by running the
> blog_id through md5 and grabbing the first 3 characters. This gives you
> a possible 4096 databases, so create that number of databases which is
> where we'll store the data for individual blogs.
> We also need a global db for things like wp_blogs, wp_usermeta and other
> "global" tables.
> So, when a query comes in, if it's a global db query then send it there,
> otherwise grab the blog_id from the query, or simply use $wpdb->blogid,
> find the right db and send the query to that db.

I thought that's what we were doing for the upload subdirectories, no
the databases.  I don't remember that one ever being explained for the
databases.

Regards,
-drmike

-- 
Blog: http://drmikessteakdinner.com
Kim Possible: Remixed: http://kimpossibleremixed.com
Get your own free hosted WordPress Blog today: http://daria.be