Performance question regarding query's and calculated attributes

[SVanSchoonlandt]

Hi all,

we have a situation where there is a calculated attribute created to build the name of an application interface based on the connected source and target applications. This works fine, however when we run query's on the interfaces the performance is very slow. Is this calculation also triggered when executing the query on the name of the interfaces? Are others having simular cases and if so, have you some suggestions to improve the case?

Thanks

stijn

[SVanSchoonlandt]

Jerome,

thanks, I executed the script and seems valuable information. I did it for 100 object occurences

I need some clarification on interpreting the results

1. Results are miliseconds?

2. What are acceptable levels for avg and max?

thanks

stijn

[jhorber]

It is frequent that execution of calculated MetaAttributes is slow.

This is usually related to the code of the custom macro involved.

Here is a example of a script that can help you detect slow executions

http://community.mega.com/t5/custom/page/page-id/mega-kb-solution?sid=501D00000010J3uIAE

Then you can verify if you can optimize the code of the custom macro.