Slow collection access

[thomaskilian]

Hi all,
I wonder if someone else has the same problem. When accessing a collection of say package elements then the collection does not seem to be cached by the automation. Instead it looks like EA is doing a single query for each GetAt. I wonder if this is a correct observation and whether Sparx could do this a bit better?

[Eve]

Have you set Repository.EnableCache to true?

[thomaskilian]

Actually I was not aware of that functionality.
But turning it on did not help so much. I saw that in certain parts EA was now consuming time instead of the SQL server. However, it was only in a few parts, and it took 2:30 minutes instead of 2:40. I guess EA is simply very chatty with the SQL server in general?!