Excessive memory usage
Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=22421
Printed Date: 16 May 2024 at 11:45pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Excessive memory usage
Posted By: PhilM
Subject: Excessive memory usage
Date Posted: 29 September 2014 at 7:16am
|
100,000 rows by 10 columns of strings up to 6 characters max uses 300mb of memory, this is 3mb per row or 300kb per item. I can understand some overhead for all the properties etc. but this seems very excessive. Using virtual mode is not an option as we require grouping. Using the global settings "UseReportCustomHeap" or "UseBatchAllocation" make no difference. Is anybody else having this problem? Is there any way of getting the memory usage down? ------------- Product: Xtreme SuitePro (ActiveX) version 17.3.0 Platform: Windows 10 / Windows 7 Language: Openedge 11.6 |
Replies:
Posted By: olebed
Date Posted: 29 September 2014 at 8:34am
|
~0.003mb per row (300mb / 100000 row) 3kb per row and 300b per item |
PhilM wrote:Posted By: PhilM
Date Posted: 29 September 2014 at 9:26am
 Thanks for the great advice  Regardless of calculations, memory usage is 300mb for 100,000 rows, this is too high, how do we reduce it?------------- Product: Xtreme SuitePro (ActiveX) version 17.3.0 Platform: Windows 10 / Windows 7 Language: Openedge 11.6 |
Posted By: Willowmaster
Date Posted: 29 September 2014 at 9:47am
Use only 5 columns? 
You could show the most important columns and retrieve the others if the row is selected and show them in a details grid.
I think I also read somewhere in the CodeJock documentation not to use 100.000 rows in the report control unless you use virtual mode, because of the limitations of the grid. ------------- Product: Xtreme SuitePro (ActiveX) version 15.3.1 Platform: Windows XP (32bit) - SP 3 (on VMWare) Language: Visual Basic 6.0 |
Posted By: PhilM
Date Posted: 29 September 2014 at 9:55am
Yeah I think we've tried to push it a bit too far, shame because it works nicely otherwise. Just thought I'd ask before giving up. Thanks ------------- Product: Xtreme SuitePro (ActiveX) version 17.3.0 Platform: Windows 10 / Windows 7 Language: Openedge 11.6 |