RE: [PHP-DB] CMS-Blog system

2008-09-04 Thread Jack van Zanen
To: Martin Zvarík Cc: php-db@lists.php.net Subject: Re: [PHP-DB] 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

[PHP-DB] CMS-Blog system

2008-09-03 Thread Martin Zvarík
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

Re: [PHP-DB] CMS-Blog system

2008-09-03 Thread Evert Lammerts
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