Skip to main content
Nintex Community Menu Bar

Expressions in List View - Performance Issues

  • October 24, 2017
  • 2 replies
  • 18 views
S
Forum|alt.badge.img+2

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

    2 replies

    Albarghouthy
    Forum|alt.badge.img+16
    • Albarghouthy
    • Scholar
    • October 25, 2017

    Hi Satyajeet,


     


    Do you have paging enabled? 


    How many rows per page?


     


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


     


     

    Mus
    S
    Forum|alt.badge.img+2

    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

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement