We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Excessive memory need with thousands of objects

Thread ID:

Created:

Updated:

Platform:

Replies:

131135 Jun 22,2017 12:04 PM Jul 3,2017 01:27 PM WPF 1
loading
Tags: ReportViewer
Georg Plösch
Asked On June 22, 2017 12:06 PM

Hello everyone,I'm searching for a practical solution for a problem with the ReportViewer. I'm working on an WPF application that get's sensor data from an external device. Therefore I have a model Data(which holds metadata for example the DateTime of Recording and so on). This object has a set of the sensor data (Measurements). In on day there are coming around 3000 till 5000+ records to the database. The customer now wants a Report with charting. I have created a View on the database where the two tables (Data, Measurments) are joined togehter (currently around 600k entries).He is also able to build report templates on his own (with the ReportDesigner). My problem occures when I want to display the chart. This will fill up all the available memory, takes a long time and chrashes the application. Despite the fact, that displaying 600k (or more data doesn't make any sense) how can I deal with it?I could create Views for the last day, week, month and create some template reports for it, but even for one week displaying the chart will not work in any good way.Can someone give me a good idea how to handle that?Kind regards

Vinoth Srinivasan [Syncfusion]
Replied On July 3, 2017 01:27 PM

Hi Georg, 
 
Thanks for your interest in Syncfusion Components. 
 
We have validated the chart behavior with 600k data in our report designer, it throws out of memory exception when chart has more number of categories. Since, we need to hold the computed point values in series till rendering the chart and that consumes more memory and throwing the exception. As an example, if we are having 600k records and that have 20000 cities then we need to hold the 2000 category point values with X and Y. In this case, we must have a memory to hold the data of report (600k) and chart point data (2000 category). If we have the case to summarize the more data with report then we suggest you to use the report to show the chart with drill through options.  
 
As an example to show sales of the country, 
  1. Main Report (Country)
  2. Sub Report 1 – Show the states wise data based on selected country in Main Report.
  3. Sub Report 2 – Show the city wise data based on selected state in Sub Report 1.
 
Please let us know if you have any other questions. 
 
Regards, 
Vinoth S. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;