Perform On Server Script

["... you mean these fans?"]

Hi,

Some Wisdom.

I am researching whether or not to utilize the "Perform On Server" script step to perform "Finds / Sorts".  And thought maybe I could get some insight

Phil had perviously help me on this issue from a previous request.  And Phil, thank you.

I am researching / understanding if the "Perform On Serve" is a better way to perform "Finds, Sorts, and Script in general"

We have a very slow data feed on one of the solution and the "FOUND" set with conditional formatting really bogs down the database.

Is there another way, maybe use "TEXT" to code a series of vertical lines to replace the conditional coloring ??   I guess it is still a calc and would have to recalculate every record so it wouldn't matter.

 

Thank you.

Tom

 

 

 

[Ocean West]

How often does the condition change?

Possibly you could store the flag value for the condition as a number and have a server side script process records either on script or some other find criteria to loop thru the records server side and set the flag statically so that that you conditional formatting is nothing more then evaluating on a stored value.

if the conditional formatting is a calculation base on the local fields record in the table then not sure there is much gain in performance if the condition is based on aggregate data or data from other tables then it would impact the display performance.