4 Replies Latest reply: Dec 7, 2017 3:41 AM by Erik Wetterberg RSS

    Restricting no of rows to be fetched in mashup - app.visualization.create('table',

    Digvijay Singh

      Hi,

       

      Need help to find standard methods of restricting no of rows in app.visualization.create('table', its causing 100% memory and CPU utilization for one of the customer when fact table rows are > 30 M.

      One way is to use calculation condition to limit rows for visualization, its not desirable to force user to limit the data and export also causing the same issue when app.createTable is used along with  table.exportData. We want to define a limit, could be any hardcoed no lets say 500K for viewing and export.

       

      Any kind of help is much appreciated. Thanks in advance.