7 Replies Latest reply: Oct 26, 2017 12:17 PM by Felip Drechsler RSS

    Guideline to solve performance problems.

    Paolo Rena

      Hi community,


      I have some performance problems related to the expression of Count({<As-of Date>} DISTINCT VISITOR_ID) in a table that have 70 Million of record for 40 column (VISITOR_ID is already Autonumbered).


      Obvious that is slow to calculate expressions (because is a big table), but 35 second to open the page and to make the calculation i think is not good for the customer.



           Is possible increase the performance using some cache solutions?

           Any other solution to make faster the expressions with count distinct calculation on big table?




      Really thanks,