RE: CMS-Blog system

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I agree it depends on the architecture, however.......
1000000 is not that many records.

I personally like to keep my data together that could/should be used together.


Jack

-----Original Message-----
From: Evert Lammerts [mailto:evert.lammerts@xxxxxxxxx] 
Sent: Thursday, September 04, 2008 7:15 AM
To: Martin Zvarík
Cc: php-db@xxxxxxxxxxxxx
Subject: Re:  CMS-Blog system

> 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?

The answers on your question depends on the architecture of your
software - if you really expect to have a big site, you'll have to
design the interfaces between the several components of your system,
both on hard- and software level.

Generally speaking I think it's easier to use one database per user -
it increases portability and scalability - you'll be able to
distribute your database servers easier.

> 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?

Use WordPress ;-)

Again, remember simple concepts of software engineering. Be careful to
implement a system that depends on one component to work - this
point'll easily become your single point of failure. I'm not just
joking about wordpress, why develop another system in the wild world
of open source CMS's? Take a look around - it'll save you loads of
development headaches.

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


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



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux