On Tue, 25 Jul 2006, Bisma Jayadi wrote:
I would consider 250 tables rather moderate.
Wow... if 250 tables still considered as moderate, I wonder how many tables
will you considered as huge? I've build some large scale database application
but I never use more than 200-300 tables. If the tables more than 300 (max
500, IMO) then I think there's something wrong with the system design, and
the system need to be redesigned or separated.
In enterprise class systems 500 tables or more is not uncommon.
ASP based systems easily use 10.000 tables. That qualifies as huge.
Fortunately most of these are managed by ASP itself :-)
I can assure you that the 250 tables I'm talking about is limited in the
sense that we try to re-use a lot of tables. If we didn't and adhered to
strict normlization, there would be 500 tables easily...
But all depends on the class of applications you are working on.
I suppose that for the average SMB application or open
source project, 250 tables is indeed a lot.
Michael.
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
