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