Antonio Bassinger wrote:
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.
Take a look at bitweaver
www.bitweaver.org
Fully operational user management and file upload with management that
allows it to be fully scalable.
It will give you some practical examples at least ;)
--
Lester Caine - G8HFL
-----------------------------
L.S.Caine Electronic Services - http://home.lsces.co.uk
Model Engineers Digital Workshop -
http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
