Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
430
UltraGrid and CalcManager performance and memory problems
posted
Hi all,

we are experimenting critical performance and memory problems when 'stressing' the UltraGrid with some column formulas.

if we do not have formulas the grid can handle quite nicely 30.000 rows and 120 columns (3.6M cells) without consuming more than 30-40Mb of memory but if we use column formulas (around 30% of the columns) when we call the calcmanager.Recalc(-1) the memory increase over 1Gb and the application die with an outofmemory exception.

 We followed all your recommendations with the grid to avoid using directly the UltraGridCell to access values (using the row.GetCellValue) and some other recommendations written in the http://news.labs.infragistics.com/forums/p/15306/56104.aspx#56104 post but we are running into critical problems when dealing with the calcmanager under these conditions.

 Is there a way to optimize the calcmanager to avoid such problems?thanks,Luis.