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 post. I have been looking into your sample application and I can see a delay only when restoring a column sorting. Could you please tell me if this is your scenario because I need to have specific steps for reproducing an issue?
Looking forward to hearing from you.
All restoring procedures are slow: eg. Grouping by Text1 than by TrueFalse. Restoring needs a long time.
Did you notice the size of the configs (Byte-Array)? Between 20 and 30Mb each.