Oracle connection causes delays

[Sandeep]

I am trying to use Oracle and CVS to get a team based modeling set up for TR write up. The plan is ot eventually move my entire online team, from Business Requirements to Testing, into model based architecture.

However, I am finding that if the developer connects to a server and start checking out the model, it takes him upto 2 hours to check the entire model. I have no problems connecting to the dB using TOAD. If I work off a local machine, I can check out the entire model in less than 5 minutes.

Any idea on what could be wrong?

[thomaskilian]

No, except that EA is very chatty with its database. Try using XMI and local databases.

[Sandeep]

 

Would that amount to getting my entire team running Oracle (not the client) locally on their machine?

[«Midnight»]

Just adding another 0.02 CAD...

I think I've seen something about delays when version control checks out large models from a DBMS back end. I could be wrong here, and I just cannot remember the precise context.

Consider partitioning your model so that individual developers (or small groups thereof) work on separate package trees. [This might not be realistic in your organization of course.] That might ease check-out time while you are working. You'd still be left with the same delay when doing work with the model as a whole.

Other than that, you could work with individual Oracle implementations, but that could be a headache. It would also impose constraints if you move to Oracle 11. [Last I looked, shortly after the launch of version 11, the Express product was still at version 10. This may have changed.]

You might be able to set up several smaller projects on your corporate Oracle server. Each would implement a portion of your project, perhaps with some common stuff that would be treated as read-only. You could then have groups or individual developers work against these. You might be able to handle common elements via controlled packages. Look at the EA docs for information on that feature. It is quite old, but still serves a purpose, and it works well.

David

[thomaskilian]

David,
the slow CVS was one of my issues. But that accounted only for several minutes for the startup - not hours. So I assume it's simply the chatty EA slowing it down.

Sandeep: try loading the model diretly on the server. If that's fast you likely have the explanation.