Separate or 1 database ?
| From: | Martin Zvarík | Date: | Wed, 03 Sep 2008 21:00:37 +0000 |
| Subject: | Separate or 1 database ? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-45357@lists.php.net to get a copy of this message | ||
I have a basic question - I believe there are only two options - which
one is better?
1) having separate databases for each blog = fast
(problem: what if I will need to do search for article in all of the blogs for some?)
2) having all blogs in ONE database - that might be 10 000 * 100 articles = too many rows, but easy to search and maintain
I appreciate your discussion on this topic.
Martin Zvarik