Performance (lots of tables / databases...)

From: Date: Sat, 27 Sep 2008 14:53:19 +0000
Subject: Performance (lots of tables / databases...)
Groups: php.db 
Request: Send a blank email to php-db+get-45478@lists.php.net to get a copy of this message
Hi, I am working on a blog system and I am currently thinking of what would be the best DB approach. I have read lots about wordpress and other blog's optimizations and DB structure, but I have not found any mention of having separate database for each blog/user. So, my question is, which one is performance better (talking about 1000 blogs): a) 1000 blogs * 5 (let's say we will have tables like comments, post... for each blog) = 5000 tables in one database ... this is Wordpress default b) 1000 databases (for each blog) each having 5 tables c) 5 databases by 1000 tables - in this case, won't this be an issue when SELECTing like this: [db_comments].testblog, [db_posts].testblog ? Is that a controversial topic? :-/ Thanks for ideas, Martin

« previous php.db (#45478) next »