January 30, 2009 at 6:02 am
Hi
Is there a way to keep compresed data in a database?
I have to store a xml file,that is a text field in my database
This xml's are quite big, so I wonder if there is a way to compress them, and decompress when I extract them, is that is possible.
Or is better with xml datatype?
Thank you
January 30, 2009 at 6:11 am
You could upgrade to 2008 which has compression built in.
The other option that comes to mind is to compress them using, something, pkzip?, and then store them as a binary. That would work, but it will certainly slow down the storage & retrieval of the data.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 30, 2009 at 10:12 am
Ok
It seems that this is the only solution...
I need to use it in 2005...so I will try your way
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply