Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: Model Trainer on June 20, 2024, 02:08:10 am

Title: Deleting a package
Post by: Model Trainer on June 20, 2024, 02:08:10 am

Hi,

I imported several process maps from a BPMN modeling tool into Sparx repository, where I'm working mainly within ArchiMate notation. Now, it seems that my model is so huge to be processes timely, so I decided to delete those processes from my model, but it took almost 1 hour and Sparx couldn't do that. It seems that Sparx has crushed. What's the issue? and does any body know any solution to that?

Bets Regards

Title: Re: Deleting a package
Post by: Geert Bellekens on June 20, 2024, 04:01:17 am

The solution depends on what the actual problem is.

In normal circumstances, you should be able to add any number of models without a noticable impact on the performance.

That however depends on two things:

the database you are using
  Good: MySQL, SQL Server, SQLite (.qea file),..
  Bad: Jet(.eap), Oracle
the connection to that database
  Good: local file, machine in the same network
  Bad: WAN connection over a VPN from client to database

Geert

Title: Re: Deleting a package
Post by: wivel on June 20, 2024, 07:48:12 am

Have you tried deleting them in smaller chunks?

Henrik

Title: Re: Deleting a package
Post by: Model Trainer on June 21, 2024, 04:12:41 am

We don't have any special DBMS for Sparx now. We're saving them on a file-based repository within our shared or local places.

I tried to delete them in chunks, but even with this approach, Sparx is crushed and tried to work almost 50 minutes without any result.

Title: Re: Deleting a package
Post by: Geert Bellekens on June 21, 2024, 02:41:52 pm

Quote from: Model Trainer on June 21, 2024, 04:12:41 am

We don't have any special DBMS for Sparx now. We're saving them on a file-based repository within our shared or local places.

I tried to delete them in chunks, but even with this approach, Sparx is crushed and tried to work almost 50 minutes without any result.

For local files it also matters which one.
Move to .qea if possible, or even better, move to real database.

And maybe try a Project integrity check before deleting.

Geert

Title: Re: Deleting a package
Post by: DeBAAT on June 21, 2024, 03:31:09 pm

It looks like this may be too late or might not be appropriate at all, yet I would like to make the remark. Sorry for that.

In situations like this, I try to add these kind of large chunks to a copy of the repository to do some testing first.
It is especially easy when working with file based repositories.
That way the original file is still available for normal operations.