Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: Dave_Bullet on September 03, 2008, 07:55:32 am

Title: EA832 - project load speed still slow
Post by: Dave_Bullet on September 03, 2008, 07:55:32 am

I got really excited (like a kid at xmas) when I saw build 832 had optimisations to improve the project load speed on large models....

Well... I tried it and no difference.   :( Has anyone else noticed a speed improvement on 832?  My model is SQL Server with approx 6300 elements and 2700 packages

Thanks
David.

Title: Re: EA832 - project load speed still slow
Post by: Eve on September 03, 2008, 08:21:05 am

No improvement?  That's disappointing.

That's not a particuarly large model though.  It only takes me ten seconds to load a mysql model with over 14000 elements, and I wouldn't consider that large.  Your model does have significantly more packages though.

One model that I have test results for showed over a 50% improvement.

Do you have a slow connection to the database?

Title: Re: EA832 - project load speed still slow
Post by: Martin Terreni on September 03, 2008, 02:52:30 pm

I have a project with more then 45K elements and I got a substantial boost I must say...

Title: Re: EA832 - project load speed still slow
Post by: Eve on September 03, 2008, 03:05:21 pm

That's good.

I would expect a higher proportion of load time to be cut the larger a project is.  (We were testing with greater than 100K elements.)

Title: Re: EA832 - project load speed still slow
Post by: Dave_Bullet on September 04, 2008, 11:58:39 am

good to see others gettign a huge boost.

Maybe its the packages.  Simon - Are your large 100K + element models mostly "non-package" elements?

I also don't know why EA needs to traverse through the whole package hierarchy (you can see it iterating through in the status bar, displaying each package name).

Can EA not retrieve on demand (ie. breadth first retrieval of the hierarchy - down to a user configured depth, then lower level packages are retrieved on demand when expanded).

Network bandwidth is not the issue (we have 100MBit + to our datacentre which is never saturated).  It might be the number of hops.  A trace route reveals 6 hops with a total time of 33msec (each way I think).  IF EA is issuing several queries on initial project load, that latency can add up.

Maybe a bit much to ask (and it doesn't matter too much once you are loaded), but an ideal time to load any sized project would be under 5 seconds (excluding initial model diagram open).  I think this is quite achievable if an ondemand load strategy is used as described.

Thanks,
DAvid.

Title: Re: EA832 - project load speed still slow
Post by: Martin Terreni on September 04, 2008, 05:44:53 pm

I agree with Dave it would be better.

BTW, in our case we have about 5.5K packages.