Performance issues - time taken to export & import

[ChrisBD]

We have a very large model (over 100,000 elements) that runs using a MySQL repository and ClearCase version control.

Some of our users are experiencing lengthy delays in checking out packages.

I have been performing some tests that exclude the ClearCase interaction, by exporting and importing data to XMI files.

The package that I have chosen consists of 10483 elements (529kb XMI file) and it takes 24 minutes to import and about 9 minutes to export.

Is this to be expected or is there a method of speeding this up?

I have noticed that there are a lot of "simple links" to elements within other packages, could this be the cause? If so would instance references be any quicker?

[Geert Bellekens]

Chris,

1. Have you tried this on version 8? There are a lot of performance improvements in that version.
2. Have you applied the new database schema? That is something you can do even with version 7.5, and it contains a lot of extra indexes and stuff to improve performance
3. 10.000 elements in one package seems a bit over the top to me . Try splitting up in smaller packages.

Geert

[ChrisBD]

I certainly agree on the package sizes. We are planning on splitting the model up in the near furture (an automated process due to its size).

I want to run the new patch on a test copy of the database first and will do so when I can get an sqldump to rebuild it from so that I can perform a comparison and put that data forward as justification of running the patch now.

I haven't tried version 8 as yet, I gather that there's a critical bug involving the GetAllLatest overwriting items that are checked out and locked! But I'll look at testing this example.

[Geert Bellekens]

Chris,

We recently upgraded our database (SQLServer 2000 to SQLServer 2008) following the procedure:
1. Disable write access to SQL2000
2. Create database (new schema downloaded from website) on SQL2008
3. Perform project transfer from SQL2000 to SQL2008
4. Enable access to SQL2008

That procedure went pretty well and ended in about 45 minutes for our model (about 50.000 elements)

Geert