I reverse engineered our SQL Server database into TDM 3.0 and the resultant data model was 15MB!..
None the less, TDM was slloooowwwwww…our data model has about 636 entities and several thousand attributes and foreign keys.
Also, after I saved the model, and tried to reopen TDM, it locked up my machine. The only thing I could do to reload the model, was to move the model to another directory on the disk, open up TDM, and watch the errors…Then close TDM.
After that, search for the model, and load it with TDM. At this point, it was off to get a cup of coffee…(actually 3 cups of coffee were drank before the model loaded…)
As it was loading, I opened up the Task manager, and TDM used 160MB of memory, and had about 450,000 page faults…hmmm…