Reducing String Size By Zipping And Storing In Object
<p>Our application at work basically has to create over a million objects each night to run a numerical simulation involving some weather observations that were recorded during the day.</p>

<p>Each object contains a few string properties (and one very large xml property - About 2 MB) - Beacuse of the size of the large xml property we dont load this up and instead prefer to go the database when we need access to this xml blob (which we do for each object)</p>

<p>I was wondering if it makes sense to somehow retrieve the xml data (which is 2MB) compress it in memory and store it in the object - This prevents us having to do a database query for each object when we come to process it.</p>

<p>I would much rather zip the data, store it in the object and at processing time, unzip and process</p>

<p>Is it possible to zip a string in process and how can I do this without creating millions of MemoryStreams / zip streams for each object?</p>
