Codejock Developer Community : Excessive memory usage http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 14 May 2026 09:42:38 +0000 Mon, 29 Sep 2014 09:55:34 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=22421 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Excessive memory usage : Willowmaster wrote:Use only...]]> http://forum.codejock.com/forum_posts.asp?TID=22421&PID=72797&title=excessive-memory-usage#72797 Author: PhilM
Subject: 22421
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
]]> Mon, 29 Sep 2014 09:55:34 +0000 http://forum.codejock.com/forum_posts.asp?TID=22421&PID=72797&title=excessive-memory-usage#72797 <![CDATA[Excessive memory usage : Use only 5 columns? You could...]]> http://forum.codejock.com/forum_posts.asp?TID=22421&PID=72796&title=excessive-memory-usage#72796 Author: Willowmaster
Subject: 22421
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.
]]> Mon, 29 Sep 2014 09:47:41 +0000 http://forum.codejock.com/forum_posts.asp?TID=22421&PID=72796&title=excessive-memory-usage#72796 <![CDATA[Excessive memory usage : olebed wrote: PhilM wrote:100,000...]]> http://forum.codejock.com/forum_posts.asp?TID=22421&PID=72795&title=excessive-memory-usage#72795 Author: PhilM
Subject: 22421
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?




]]> Mon, 29 Sep 2014 09:26:36 +0000 http://forum.codejock.com/forum_posts.asp?TID=22421&PID=72795&title=excessive-memory-usage#72795 <![CDATA[Excessive memory usage : PhilM wrote:100,000 rows by...]]> http://forum.codejock.com/forum_posts.asp?TID=22421&PID=72794&title=excessive-memory-usage#72794 Author: olebed
Subject: 22421
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

]]> Mon, 29 Sep 2014 08:34:19 +0000 http://forum.codejock.com/forum_posts.asp?TID=22421&PID=72794&title=excessive-memory-usage#72794 <![CDATA[Excessive memory usage : 100,000 rows by 10 columns of...]]> http://forum.codejock.com/forum_posts.asp?TID=22421&PID=72793&title=excessive-memory-usage#72793 Author: PhilM
Subject: 22421
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?
]]> Mon, 29 Sep 2014 07:16:20 +0000 http://forum.codejock.com/forum_posts.asp?TID=22421&PID=72793&title=excessive-memory-usage#72793