3 Replies Latest reply: Aug 5, 2012 3:00 PM by Ramon Schweizer RSS

    Performance Problems with Count/Sum function



      i have a qvw Script in a Server environment with max. 5 tables.

      In one table i have a field with IDs and i created a data set count field (1 as FieldID) to sum or count it at the UI, but the performance is very slow.

      The Table with the FieldID have ca. 60 Millions data sets.The server have a little more than 24 GB RAM.

      Habe anyone have an idea why the performance is so slow?