UltraGrid and CalcManager performance and memory problems

State See Verified Answer
Replies 2 replies
Subscribers 6 subscribers
Views 638791 views
Users 0 members are here

430

Luis posted over 16 years ago

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.

Parents

No Data

Reply

469350

Verified Answer
Offline Mike Saltzman posted over 16 years ago

Hi Luis,
There are quite a number of variables here, so it's hard to say what might be causing the issue. My recommendation would be that you try downloading the latest Hot Fix and see if that helps. If not, then you should create a small sample project demonstrating the issue and Submit an incident to Infragistics Developer Support so they can check it out.
Cancel
Reply

Reject Answer

Cancel

Children

430

Luis posted over 16 years ago in reply to Mike Saltzman

isn't there a 'good practices' manual for the calcmanager and the formulas it can handle? It seems that it is creating a huge amount of memory for doing its job.

thanks

Luis.-
Cancel
Reply

Cancel