Data Modeling

[Ryo-Ohki]

I am using EA 8.0.864. I have a data model with 204 tables on the same diagram that was reversed engineered from a sql server db. My eap project is 5 MB but performance is terrible when trying to move a table or connector anywhere on the diagram. I have disabled auditing, and cleared the logs but am not seeing any improvements. Has anyone else encountered a similar problem?

[Paolo F Cantoni]

I am using EA 8.0.864. I have a data model with 204 tables on the same diagram that was reversed engineered from a sql server db. My EAP project is 5 MB but performance is terrible when trying to move a table or connector anywhere on the diagram. I have disabled auditing, and cleared the logs but am not seeing any improvements. Has anyone else encountered a similar problem?

No - because it is NOT viable to manipulate a diagram with that many objects on it.

Create subset diagrams containing related areas of objects.

I've developed a commercial add-in that will automatically create "neighborhood" diagrams for each element -- showing the objects that are directly related to that "root vertex".  It allows you to focus on that's happening at the local level.

What use case does that massive diagram elaborate?  If you can't see a need for it, don't use it.

When I reverse any decent size DB, I disable the creation of that diagram, it's of no effective use to me.

I have a model (both as SQL Server and .EAP) file with over 60 separate databases and 6000 individual DB items and 7000 diagrams which operates with no "ill effects".  It's about 250Mb as an .EAP

HTH,
Paolo
(PS: Contact me off-line if you'd like to try the Add-In (in beta))