Slow formula

[huytonscouser]

I have cr11

and I have this formula :-



evaluateafter({@Create cluster});

global stringvar clustergroup;

global stringvar currenthostorhbaalias;



if "Orphan" in {@Get current hostorhba} and clustergroup <> ""
then uppercase({@Get current hostorhba}) + " Possible Host(s) = " + clustergroup
//



else if "Orphan" in {@Get current hostorhba} and clustergroup = ""
and not(isnull({SRMARRAYDEVICE.SHAREDOBJECTLIST}))
then uppercase({@Get current hostorhba}) + " Possible Host(s) "
+ {SRMARRAYDEVICE.SHAREDOBJECTLIST}





else ({@Get current hostorhba})





I recently added the "else if" logic to add SRMARRAYDEVICE.SHAREDOBJECTLIST if not null.



This is causing a large slowdown for the report run time. Used to be ~10 mins, now about ~70 mins.



Only thing i can determine is that SRMARRAYDEVICE.SHAREDOBJECTLIST has a database type of String[4000]



not sure what to try.