SaveBinary on a 100X100 grid with only backcolor assigned and font of bold, without any text takes 11 seconds (machine with CPU 2GHz, Memory 512MB), and generates a 2MB file. SaveBinary on a grid of 1000X1000 takes 10 minutes, generates 16MB of data. Not to mention SaveSoap.
Saving an excel file of 100X100 with same settings takes a lot less.
I wonder how can I improve this?
ADAdministrator Syncfusion Team May 7, 2003 08:09 AM
We will have to look into this. It looks like we should not rely on plain .NET serialization to save the state but instead provide our own file format.
We are actually working on a Xml based solution for the 2.0 version but that is not ready yet. I will let you know once I have more concrete results.
ADAdministrator Syncfusion Team May 7, 2003 08:13 AM
One way you can reduce the amount of data that has to be written out is by creating a base style (in GridModel.BaseStylesMap) where you save the back color and font information and then assign this base style to cells.