By default, the ASPxPivotGrid stores data in memory for quick access. This avoids repeated database calls when performing various operations that don't require reloading data (e.g. rearranging or hiding columns). As a result, this increases the Web application scalability.
To disable data caching, set the EnableRowsCache option to false. This can be useful, for instance, when the ASPxPivotGrid displays real-time data. It's also recommended that you disable this option when binding to data created at runtime, because calling the DataBind() method always reloads data from the server.