GetByName or iterating Collections

[OpenIT Solutions]

Hi,

Has anyone else noticed a marked performance difference using the Java API's Collection.GetByName as opposed to Iterating through the Collection. I want to do the latter as i want to compare Alias not Name fields. However the interator approach appears to run an order of magnitude slower (5 mins to update 2000 elements usign GetByName - over an hour using an iterator).

Any advice appreciated....

Regards,

Jon.

[Paulus]

Don't know about that but if i understand you correctly you are loading all repository elements in order to find those which match a certain alias in order to update these?

If that's so then using a named query with the Repository.GetElementsByQuery method should make a big difference.

regards,

Paulus

[Geert Bellekens]

Jon,

I never ever use getByName() because I don't trust it.
In most cases it is possible that there are multiple elements with the same name in the collection, and in that case I don't know which one it will return.

Also, iterating EA.Collections is always a performance killer. I avoid it wherever possible.
If you are looking for elements you can indeed use the GetElementsByQuery, otherwise you case use Repository.SQLQuery to fetch the id('s) of what you are after use use the Repository.Get<XXX>ByID() operations to get the actual objects.

If you look at the EA Navigator code there are a lot of examples like that.

Geert

[OpenIT Solutions]

Thanks both for your responses. Ill check out the query approach...