Messages

1

Bugs and Issues / Re: Diagram Running Slow

« on: August 02, 2018, 07:50:14 pm »

thanks geert appreciated

2

Bugs and Issues / Re: Diagram Running Slow

« on: August 02, 2018, 06:28:15 pm »

Number of items i have in the diagram is approx 260, with a lot of relationships.

That is way too much to be on a single diagram, unless you are designing wallpaper .

Split the diagram up into smaller usable chunks.

Geert

Sadly that is the spilt up diagram, i cannot get it down any smaller without losing some much needed context

3

Bugs and Issues / Re: Diagram Running Slow

« on: August 01, 2018, 07:48:53 pm »

I am currently using an EAP file, i am looking to move to an SQL server in the coming weeks as we need to connect and read other systems from it.
There are currently 7 windows docked as such, they are unpinned docked if that makes sense. Traceability is open, as is project browser, resources, layout tools, toolbox, etc.
Number of items i have in the diagram is approx 260, with a lot of relationships. The whole model has over 300k relationships to give you an idea of complexity. The relationships in the diagram are turned off in diagram properties.

4

Bugs and Issues / Diagram Running Slow

« on: August 01, 2018, 03:24:31 am »

Hi All

Has anyone experience an issue where a diagram just runs very slowly, take ages to open, navigating takes a few mins as well as adding/moving objects around?
i have tried rebuilding the diagram but the issue is exactly the same once rebuilt. All integrity checks say there is not issues.

all suggestions welcomed

thanks all

5

General Board / Re: Absolute Novice at SQL

« on: July 14, 2018, 12:05:07 am »

thank you arshad, much appreicated

6

General Board / Absolute Novice at SQL

« on: July 13, 2018, 10:05:12 pm »

hi folks, as well as being very new to EA as a software package and as career i am trying to learn as best i can. I am having some difficulty with learning SQL side of search the model

My initial SQL bore some fruit which was the very simplistic following:

Code: [Select]

SELECT ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE, Name FROM t_object

where Name like '*Benefit*' or Name='*Benefit*'
I wanted to add some information to the search so that i can figure out where in my model this is found, borrowing from Geert's sql searches i devised the following to get some extra columns, where i am looking to get packnames and stereotypes listed

Code: [Select]

SELECT ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE, Name as Name
,package.name as 'Package Name' ,package_p1.name as 'Package level -1',package_p2.name as 'Package level -2',package_p3.name as 'Package level -3'

from (((( t_object
inner join t_package package on package_id = package.package_id)
left join t_package package_p1 on package_p1.package_id = package.parent_id)
left join t_package package_p2 on package_p2.package_id = package_p1.parent_id)
left join t_package package_p3 on package_p3.package_id = package_p2.parent_id)

where Name like '*Benefit*' or Name like '*Benefit*'
Sadly i cannot make this work and i have no idea why it wont work, can anyone point me in the right direction?