On Wed, Sep 3, 2008 at 5:01 PM, Martin Zvarík <mzvarik@xxxxxxxxx> wrote: > Hi, > > I am working on CMS-Blog system, which will be using approx. 10 000 users. > > 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 in all of the blogs for some > article?) > > 2) having all blogs in one database - that might be 10 000 * 100 articles = > too many rows, but easy to search and maintain, hmm? > > --- > > I am thinking of having some file etc. "cms-core.php" in some base > directory and every subdirectory (= users subdomains) would include this > "cms-core" file with some individual settings. Is there better idea? > > I appreciate your discussion on this topic. > > Martin Zvarik > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > I donno, 10,000 * 100 = 1 million. That's not really big. A good database should hold up with 100x that or more. I would keep it in one if it were me. -- -Dan Joseph www.canishosting.com - Plans start @ $1.99/month. "Build a man a fire, and he will be warm for the rest of the day. Light a man on fire, and will be warm for the rest of his life."
