Loading EA

[sherey]

My EA is loading very slowly, taking sometimes at least 15 minutes to load.  It seems to be trying to communicate with Outlook and getting to stuck. I just uninstalled and reinstalled and am still having this issue.

Thanks!

[Eve]

EA doesn't normally try to communicate with outlook (or anything else for that matter) on startup.

Check your add-in list.
Check your technology list for technologies from a URL. A network drive could also cause an issue theoretically.

[Geert Bellekens]

If it is slow loading a model then you also need to check the connection to the database.
In case of a .eap file that is an MS Access database stored somewhere, and if that somewhere is a remote network drive with poor connectivity then you will experience slow loading times.

In case of a DBMS you'll need to check the bandwidth and network speed to the database server. It is also know that some databases perform better then others (Oracle has a very bad reputation, MySQL and SQL Server seems to perform very well)

The thing is that EA communicates to the database using lots (sometimes up to hundreds or thousands per second) of very small queries.
Some databases seem to be able to handle that type of usage then other databases.

But in any way, the network speed and bandwidth between the client and the database (in whatever form) will be very important to the overall performance of EA.

Geert

[blang]

Hi, I can confirm that Oracle (11.2.0.3) performs very badly with Sparx EA. In our Enterprise WAN, the loading time of a diagram with e.g. 100 or 200 elements is 30 seconds or more. Even opening a property dialog for a single element takes 10 seconds. The worst Thing is draging & droping a multi-selection of elements from the Project browser to a diagram. It takes SECONDS for each single element and Sparx EA isn't even able to correctly maintain visual feedback (including Cursor shape) properly during this Operation.

@Geert: just because of this latency problems, we currently think about migrating our repository from Oracle to MSSQL. Do you have specific experience with that scenario or do you know of companies which successfully went this way?

Beat

[Geert Bellekens]

Most of my clients are now on SQL Server, an some migrated from Oracle.
The migration usually goes without a problem using project transfer.
Some helpful pointers:

- use an intermediary .eap file for the model transfer (so from Oracle to .eap and then from .eap to SQL Server) You wouldn't think so, but this is in most cases faster then directly from Oracle to SQ -L Server, and at least you have an intermediary result in case something goes wrong along the way.
- run a project integrity check (and fix all errors) before starting the migration process
- turn on the log file. In one case something went wrong with the transfer and we only figured out afterwards that none of the attributes (or attribute tags) where transferred.
- make sure you are logged on with DDLAdmin rights on SQL Server

Geert

[Eve]

Hi, I can confirm that Oracle (11.2.0.3) performs very badly with Sparx EA. In our Enterprise WAN, the loading time of a diagram with e.g. 100 or 200 elements is 30 seconds or more. Even opening a property dialog for a single element takes 10 seconds. The worst Thing is draging & droping a multi-selection of elements from the Project browser to a diagram. It takes SECONDS for each single element and Sparx EA isn't even able to correctly maintain visual feedback (including Cursor shape) properly during this Operation.

I'd guess you're using the Oracle ODBC driver instead of the OLE driver. It makes a big difference.

[blang]

No, we are using the Oracle Provider for OLE DB, same minor version as the database.

Beat