Book a Demo

Author Topic: over wan get all lastest takes hours to complete  (Read 4162 times)

Hardeepm

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
over wan get all lastest takes hours to complete
« 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  

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: over wan get all lastest takes hours to comple
« Reply #1 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.

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: over wan get all lastest takes hours to comple
« Reply #2 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.

Doug Blake

  • EA User
  • **
  • Posts: 102
  • Karma: +0/-0
    • View Profile
Re: over wan get all lastest takes hours to comple
« Reply #3 on: September 28, 2012, 05:39:28 pm »
Shared database .... I'd definitely recommend it
DGB Using 12.0.1214 / eaDocX 3.6.2.1 / MSSQL / TFS / Windows 7 / IE11

Hardeepm

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: over wan get all lastest takes hours to comple
« Reply #4 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?

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: over wan get all lastest takes hours to comple
« Reply #5 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.

Hardeepm

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: over wan get all lastest takes hours to comple
« Reply #6 on: September 28, 2012, 10:12:15 pm »
thanks so much for all your help  :)