Tables vs. databases
| From: | Antonio Bassinger | Date: | Fri, 09 Jun 2006 17:10:46 +0000 |
| Subject: | Tables vs. databases | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-237705@lists.php.net to get a copy of this message | ||
Hi gang,
Situation:
I've a HTTP server. I intend to run a file upload service. There could be up
to 10000 subscribers. Each saving files up to 10 MB.
I made a proof-of-concept service using PHP & MySQL, where there is a single
database, but many tables - a unique table for each subscriber. But I
realize that I may land in trouble with such a huge database. Would it be
better to have a separate database for each subscriber?
Which approach is better, many tables in 1 database, or many databases with
1 or max 2 tables?
Kindly suggest with pros and cons of each.
Thanks & Regards,
Bassinger