EA on ORACLE Database

[AlanH]

Hi guys,

we have just begun testing EA using an ORACLE Database and my initial connection time following the upload of 42Mb of data was 3 minutes...

This is not really acceptable from a user perspective these days and I was wondering if this is usual or if our configuration could be tweaked in some way?

Any ideas?

Al

[glen_kidd]

I've tried a 110Mib EAP with Oracle 10g. My connect time was approximately 120 seconds.

I've noticed, contrary to my expectations, that EA via DBMS(Oracle) is consistently 30+% slower than accessing an EAP on a network drive.

Has anyone else had more luck with DBMS experiences? Any Oracle tuning hints?

[AlanH]

Thanks Glen,

were you running a local install of Oracle or was that a networked version?

My version is on the network and the DBA reckons the DB access only takes about 10 seconds, so the time is lost somewhere on the network and in the pre-prep and presentation...

Al

[glen_kidd]

I was connecting to a networked Oracle.

I don't have the figures (it was many months ago), but I recall similar slowdowns with MySQL. Also, the slower the round-trip time on the network (try it over DSL!), the slower EA gets with both EAP or DBMS, but it seems to get worse with DBMS.

I have observed very little network traffic and load on the db machine.

Out of curiosity, I tried to access the networked EAP via the ODBC Microsoft JET4 provider. In this case, the response time was very similar to accessing the networked EAP directly - very strange.

So it does appear that EA responsiveness is:
1. influenced by round-trip delay, and
2. heavily influenced by EA's handling of non-JET DBMS.

[z.kadlec]

Hi,

does have somebody some new info's in that?

We have EA used for cca 35 concurrently working users on one network ORACLE 9 repository.

We model there whole business processes of a bank and we maintain there the internal rules generated from process diagrams.

The size of the EAP file when the Oracle DB is transferred into MSAccess is currently cca 150MB.

The connection time is cca 2-3 min.

It is pitty that EA loads ALL packages on the start - our users typically works with one subsubsub...package for the whole day.

Problem is when I need to read elements of a package in Add-In - it takes a significant number of second in case of package with about 10 processes inside and with 20 steps per process as subelements.

Have a nice weekend

Zdenek

[«Midnight»]

Take a look at Controlled Packages in the EA documentation. This is an old feature, but can work well for some forms of sharing.

If you have users who work on only specific part(s) of your package tree, and if they - as single users or small groups - are the only people making changes to those sections of the model, then perhaps you could use this feature to provide them with just the parts they need.

Make sure you manage GUIDs properly though. You want the changed packages and elements to update properly when the controlled packages are imported.

I believe the API has the necessary functionality to support this through automation.

HTH, David

[Martin Terreni]

We work on MSSQL2005 from Israel and India (about 40 people) with about 1000 packages (don't know how big it is) and with TFS version control. It takes about 20 secs to finish loading.
My customers work over many parts of the world with many more users and larger repositories. We deisided (still not deployed) to use local EAP files conected to the packages under VC for users working fron WAN and DB (MSSQl2005) with VC and repplications for LAN users.
We still have to check it, but it seems to me it will be better then the figures you present here, specialy becuse WAN users will be working against a local EAP on their comp.