I generated a large (31K items) pivot collection whose cxml file exceeds 21 megs. I would need to host this on a website however 21 megs is going to take a long time for the client silverlight pivot viewer control to load. I intend to use gzip compression to serve the file however is there anything better that can be done?
Is there a way to compress a Silverlight Pivot Collection's cxml file?
Using compression on the web server is your only real bet.
However, 31k is not going to work very well. Typically, if you break the 3k mark you start seeing bad performance, slow load times, etc.
I would look at your data and see if there is a way to break it up. Either linking collections, creating hierarchies, etc. That would get your users a better experience.
Sorry there isn't a better answer for you.