Skip to main content

Hello,

 

Has anyone ever faced any performance issue when expressions are used in List View ?

 

Think of this scenario. I have a list view that has 5 columns and the last column value is the difference between 3rd and 4th column. i tried doing this by using expressions. But this made the load time of the list view increase considerably.

 

The woraround , I did, for this was to do the math (difference) in the SPROC that drives the list view and load time reduced by at least 40% when compared to the first case.

 

Appreciate a response on this.

 

Thanks and Regards,

Satya

Hi Satyajeet,


 


Do you have paging enabled? 


How many rows per page?


 


Can you attach screenshot of your expression and example of the values?


 


 


Hey Mustafa,

 

Hope you are doing great !!!!

 

No, we do not have paging enabled in the view . 

 

Let me rephrase it like this :

 

We have implemented  mutiple conditional stylings in the 5-6 columns we have. And, I guess, the way K2 works is it loads all the rows with values in the list view and then starts applying the conditional styling isn't it ?

 

So, as a workaround we moved the conditional styling to SPROC .

 

Note that the list view will have 254 rows to be precise  on which it has to apply styling and the logic for conditional styling is such that not even a single row is missed out.

 

The styles are as follows  :

if any value in any of the column is zero, then change the colour to RED.

if any value in any of the column is negative , then enclose the value in paranthesis.

 

Appreciate your response and advise.

 

Thanks and Regards,

Satya


Reply