cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Performance question regarding query's and calculated attributes

Highlighted
Regular Contributor

Performance question regarding query's and calculated attributes

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

2 Replies
MEGA

Re: Performance question regarding query's and calculated attributes

 

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.

 

 

Jerome
Regular Contributor

Re: Performance question regarding query's and calculated attributes

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