March 16, 2007 at 2:07 am
Hi,
My application send lot of data in varchar threw network. In some case data are many and network connection is tiny ...
In order to optimize, I was wondering is there a way in SQL Server 2K to uncompress data ?
the idea will be to send compress data threw the network and a PS to uncompress when recording ...
Strange idea i admit but why not ?
Thanks
March 16, 2007 at 7:48 am
How much data are we talking about? I'd be surprised if you get much optimization this way.
There isn't a way inside SQL Server to do this easily. Any stored proc would be using the SQL Server, which is usually your limited resource, not the network.
If it's a large file, then it makes sense, but you'd want to programmatically or with a script, unzip it and then load it into the server.
March 16, 2007 at 9:55 am
We are talking between 1 Mo to in some case 25 Mo of text ...
I know that time I'm going to win on the network will be lost on my apps and server time.
But the goels is to see the ratio between win and loose ...
If win is better ...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply