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.

       

      Question:

           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,

      Paolo