Hi I have huge set of data to load and format conditionally (400k+ rows and 100+ columns)
I'm using InitRow event and shared Appearance object, as explained here:
https://ko.infragistics.com/community/forums/f/ultimate-ui-for-windows-forms/15306/wingrid-performance-guide
But still getting Out of Memery exception (my PS has 16Gb mem + 30 Gb Swap...)
Do you know any solution for that ?
Maybe there is an on option to perform conditional formatting *ONLY* for displayed rows / cells, instread all dataset ?
EDIT
tested on both v. 18.2 and 19.1V. 19.1 throws Out of Memory error even quicker then 18.2 ...
Hello Maceij,
Thank you for contacting Infragistics. Are you implementing Conditional Formatting in the manner we describe in our online documentation?https://ko.infragistics.com/help/winforms/wingrid-using-conditional-formattingFrom my understanding hooking InitializeRow is not as efficient as applying appearances and conditions to a ConditionValueAppearance.
Hello Michael,
As I mentioned earlier - I;m using InitializeRow method, using your performance guide (as I didnt find other way to archive that..)
I'll be happy to try conditional formatting, but in my case condition is not such static (eg column1_value > 5).I do need perform some simple lookup based on other cells value in current row
/Basically what my "conditional formatting" function is doing is checking if external hash table contains analyzed column name (in relation to other 'row key' column) and if does it set RED background (read by end user as 'ERROR')/
It works pretty much well for smaller dataset but larger consumes a lot of memory (I guess because many cells references to appearance object) - see screen below. I was a bit surprised because I have a lot RAM + hdd swap - it should be more than enough to handle even bigger datasets
So I was searching option to show set Appearance only for displayed rows but remove for those not being shown.
EXAMPLE CODE:
CondFormatOoM.zip