Visio Enterprise Architect performance problems with Large Model

[Markus S. Gallagher]

I have been working on a ORM model that generates approximately 100
tables. VEA requires 3-4 hours to update the source model after I
modifying the Logical Diagram. Is there anything I can do to break my
model into smaller junks and still have relationships across all of the
individual models? Have other people experienced similar type of
performance issues?

Any help is much appreciated - Thanks,

Markus S. Gallagher.

 

[Scot Becker]

Hi Markus,

Are you updating (Database | Project | Update Source Models) or clicking yes
to the migrate changes dialog box? The former is substantially slower than
the latter and is not needed provided you make all non-name related changes
(e.g. adding columns, indexes, FKs, etc. ) to the ORM model first. Also,
having the ORM source model(s) already open seems to speed things up.

Scot.
................................................
Scot Becker

Orthogonal Software
www.orthogonalsoftware.com

ORM Blog: www.objectrolemodeling.com

To e-mail me, please use my first name at the domain listed above. All mail
sent to the reply-to address gets routed to a junk e-mail folder where it
will likely be deleted without being read.

 

[Markus S. Gallagher]

Scott,

I've actually experienced the opposite! After I modify the Logical Model
and try to save it, a dialogue ask me whether I want to migrate the
changes back to the source model. If I click yes, I experience the
performance problem. However, if I update the source model via
database->project->update source models it is quite fast! However, the
latter approach doesn't preserve changes to table/column names, which is
exactly what I am trying to achieve.

My system parameters are:

256 MB RAM
1.7 GHz Intel Pentium 4
Windows XP (Service Pack 1)
Visio Enterprise Architect (10.0.2705)

Thanks,

Markus.

 

[Scot Becker]

Hi Markus,

Sorry....

When I said "former" and "latter" I meant them the other way around. You
are correct: Update is much faster and I never migrate.

However, those name changes should be getting preserved when you update. Do
you have one source model or more than one?

When you say they aren't getting preserved, do you mean when you refresh the
same model or when you build a new logical model form the source? If the
former (and I am sure I have this right this time ; ) ) update should
work....

Scot.
................................................
Scot Becker

Orthogonal Software
www.orthogonalsoftware.com

ORM Blog: www.objectrolemodeling.com

To e-mail me, please use my first name at the domain listed above. All mail
sent to the reply-to address gets routed to a junk e-mail folder where it
will likely be deleted without being read.