Separate or 1 database ?

Separate or 1 database ?

am 03.09.2008 23:00:37 von Martin Zvarik

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



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php