neebee: on table designs.
| From: | phpnews | Date: | Wed, 17 Nov 2004 07:05:27 +0000 |
| Subject: | neebee: on table designs. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-37315@lists.php.net to get a copy of this message | ||
Hi All,
I have 5000+ individual clients, each clients may have 100+ records.
Each client can modify to their own records.
In the order of maintenance, robustness, scalability then performance,
which of the following do you think is best.
i) 1 big table with 500000+ records
ii) 5000+ small tables with 100+ records (1 table for each client)?
At first I thought (i) but then for robustness a colleague pointed out
that on (ii) if clients screw up their own table it will not affect anyone
else!
any comments/suggestions are very much appreciated
tony