Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: Hardeepm on September 25, 2012, 01:00:10 am

Title: over wan get all lastest takes hours to complete
Post by: Hardeepm on September 25, 2012, 01:00:10 am

We have a large number of people using the same model

Database is SQL and local SVN's however when remote users hit get all latest the entire model is unsable and take hours even if the link has tones of bandwidth before the get all latests complets  

Title: Re: over wan get all lastest takes hours to comple
Post by: qwerty on September 27, 2012, 09:08:54 pm

Sure. Get all latest will delete your entire model in the RDBMS. This will be tons of single DELETE statements. Then the XMIs will be loaded from SVN and placed backwards via a lot of INSERT and UPDATE statements in the RDBMS. Even locally this is very time consuming.

You should consider setting up a different configuration for distributed workers.

q.

Title: Re: over wan get all lastest takes hours to comple
Post by: Eve on September 28, 2012, 08:36:32 am

Of course, if everyone is using a shared database. You never need to do Get All Latest.

Title: Re: over wan get all lastest takes hours to comple
Post by: Doug Blake on September 28, 2012, 05:39:28 pm

Shared database .... I'd definitely recommend it

Title: Re: over wan get all lastest takes hours to comple
Post by: Hardeepm on September 28, 2012, 06:04:54 pm

thanks everyone for the reply.

We are all using a shared database however I thought that changes we make to the shared EA model would not update our local SVN without hitting get all latest.

Have i missed a trick here?

Title: Re: over wan get all lastest takes hours to comple
Post by: qwerty on September 28, 2012, 09:12:46 pm

You did. The shared database IS the status quo. When someone checks out a package it's locked for him and changes go to the DB directly. Everyone can see them but only that person is allowed to change the package. Once he's done the checkin will simply dump the contents of the package to an XMI file and check it into SVN as a new version. So you see: get all latest is nonsense on a shared model. As written in Sparx' white paper about CM this is only meaningful for distributed EAP files.

q.

Title: Re: over wan get all lastest takes hours to comple
Post by: Hardeepm on September 28, 2012, 10:12:15 pm

thanks so much for all your help  :)