Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - Excessive memory usage
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Excessive memory usage
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
PhilM View Drop Down
Groupie
Groupie


Joined: 24 March 2009
Location: United Kingdom
Status: Offline
Points: 65 		Post Options Post Options   Thanks (0) Thanks(0)   Quote PhilM Quote  Post ReplyReply Direct Link To This Post Topic: Excessive memory usage
    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
Back to Top
olebed View Drop Down
Admin Group
Admin Group


Joined: 01 July 2014
Location: Ukraine
Status: Offline
Points: 841 		Post Options Post Options   Thanks (0) Thanks(0)   Quote olebed Quote  Post ReplyReply Direct Link To This Post Posted: 29 September 2014 at 8:34am

Originally posted by PhilM PhilM wrote:

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...

~0.003mb per row (300mb / 100000 row)   3kb per row and 300b per item
Back to Top
PhilM View Drop Down
Groupie
Groupie


Joined: 24 March 2009
Location: United Kingdom
Status: Offline
Points: 65 		Post Options Post Options   Thanks (0) Thanks(0)   Quote PhilM Quote  Post ReplyReply Direct Link To This Post Posted: 29 September 2014 at 9:26am
Originally posted by olebed olebed wrote:

Originally posted by PhilM PhilM wrote:

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...

~0.003mb per row (300mb / 100000 row)   3kb per row and 300b per item


Ouch

Thanks for the great advice Clap 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
Back to Top
Willowmaster View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 July 2010
Location: Netherlands
Status: Offline
Points: 180 		Post Options Post Options   Thanks (1) Thanks(1)   Quote Willowmaster Quote  Post ReplyReply Direct Link To This Post Posted: 29 September 2014 at 9:47am
Use only 5 columns? LOL
 
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



Back to Top
PhilM View Drop Down
Groupie
Groupie


Joined: 24 March 2009
Location: United Kingdom
Status: Offline
Points: 65 		Post Options Post Options   Thanks (0) Thanks(0)   Quote PhilM Quote  Post ReplyReply Direct Link To This Post Posted: 29 September 2014 at 9:55am
Originally posted by Willowmaster Willowmaster wrote:

Use only 5 columns? LOL
 
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.

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
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.172 seconds.