Re: Number of tables

Thursday, August 20, 2009, 9:01:30 AM you wrote:

> i am developing a web app for thousands users (1.000/2.000).

> Each user have a 2 table of work...I finally have 2.000 (users) x 2
> tables = 4.000 tables!

If all tables are created equal, I would rethink the design. Instead of
using 2 tables per user I'd use 2 tables with one column specifying the
user(-id).

Especially changes in table layout would require you to change up to 2000
tables, which is prone to errors...

--
Jochen Erwied     |   home: jochen@erwied.eu     +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 |   work: joe@mbs-software.de  +49-2151-7294-24, FAX: -50
D-45470 Muelheim  | mobile: jochen.erwied@vodafone.de       +49-173-5404164