We encounter massive performance issues while persisting and restoring the XamGrid with large data. We want to specifiy the persisted properties, because on the one hand the stored byte-array is too large and on the other hand it might improve the performance of the restoring-process. At the moment this are our PersistenceSettings:
_settings = new PersistenceSettings { SavePersistenceOptions = PersistenceOption.OnlySpecified, LoadPersistenceOptions = PersistenceOption.OnlySpecified }; _settings.PropertySettings.Add(new PropertyNamePersistenceInfo { PropertyName = "Columns", Options = PropertyNamePersistenceOptions.PropertyName }); _settings.PropertySettings.Add(new PropertyNamePersistenceInfo { PropertyName = "GroupByColumns", Options = PropertyNamePersistenceOptions.PropertyName }); _settings.PropertySettings.Add(new PropertyNamePersistenceInfo { PropertyName = "SortedColumns", Options = PropertyNamePersistenceOptions.PropertyName });
In general we want to store the FilterRow, GroupedBy, ColumnPosition, ColumnWidth, HiddenColumns, SortedColumns. My question is for example: Do I really have to store the whole property "GroupByColumns" to know which columns where grouped? Same for the other properties.
I've attached a solution where you can reproduce the issue. Just play arround with Save and Load....
Hi,
Thank you for your feedback. Please do not hesitate to contact us if you need additional assistance when you have the time to review this.
I am affraid I had no time to further inspect this problem. I will get back to you end of February if I need more help. In general the issue still exists.
Hello,
I am just checking if you had a chance to look into this and if you would like any further assistance on the matter.
When it comes to storing properties using persistence manager, you can specify which property to store on control basis. Let say that the column width should be persisted. In this case the ColumnWidth property should be added to the PersistanceSettings’s PropertySettings collection. This will save the width of all columns of the grid. When it comes to compressing the file that is created with the saved properties, I would suggest you to use a compression for the xml file where the properties are stored.
Hm..., that was exactly my question in the first place:
In general we want to store the FilterRow, GroupedBy, ColumnPosition, ColumnWidth, HiddenColumns, SortedColumns. My question is for example: Do I really have to store the whole property "GroupByColumns" to know which columns where grouped? Same for the other properties