How to measure the data size of a SQL resopnse

Question

1.00/5 (1 vote)

See more:

Dear developers,

Is there any way that we can get the {raw materiel} of the data retrieved from a MSSQL before processing data?

Posted 30-Nov-15 23:23pm

Member 12178178

Add a Solution

Comments

Herman<T>.Instance 1-Dec-15 5:25am

Why do you need the datasize?

[no name] 1-Dec-15 5:37am

to make my decision, either to choose using a web service or directly connect to the database.

Richard Deeming 1-Dec-15 6:05am

So you want to load the data using a direct connection in order to decide whether you're going to load the data using a direct connection or a web service?

That doesn't make any sense.

[no name] 1-Dec-15 9:11am

You don't have to complain, if you don't know the answer it doesn't mean no solution is existed.
The whole idea is that I want to use a web service to improve the security of the database.. I know that the web server response size is larger than the regular SQL response since it contains extra XML tags, so I want to compare the regular size with web service's size and if there is no big difference then I will choose the web service.
I know I am making this complicated, I apologize
Thanks for your comment(s)

Richard Deeming 1-Dec-15 9:12am

So it's an up-front decision about which technology to use, rather than an on-the-fly decision for each request?

[no name] 1-Dec-15 9:27am

Sorry but I am afraid that I didn't get your idea, can you please explain more?
Also, can you please take a look on this similar subject here:

http://stackoverflow.com/questions/33964824/using-web-services-to-retrieve-data-from-a-sql-server-database/33996842?noredirect=1#comment55795200_33996842

Richard Deeming 1-Dec-15 9:30am

I mean, are you making the decision now, before you start writing code?

Because your previous comment made it sound like you wanted to decide for each query whether to use a web service or a direct connection.

[no name] 1-Dec-15 9:34am

No no only one thing is going to be used, either to use a direct connection or a web service [on the whole project level not just for a single query] so I didn't start coding yet, I am considering the performance and the security before starting to code.

Richard Deeming 1-Dec-15 9:35am

That makes more sense. :)

[no name] 1-Dec-15 9:36am

so what is your idea about that? what do you suggest?

Richard Deeming 1-Dec-15 9:40am

It depends. Is the application always going to be running on the same network as the SQL server?

2 solutions

Solution 2

Thank you everyone, I found the answer myself by using a method in SQLConnection called RetrieveStatistics which gave me the total size of bytes received and many other important Information I need.

You can check an example right here:

https://msdn.microsoft.com/en-us/library/7h2ahss8(v=vs.110).aspx[^]

Posted 5-Dec-15 1:05am

Member 12178178

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

FrancoisViljoen · Accepted Answer · 2015-12-01T22:47:00

Solution 1

I would not sacrifice security to get data to load faster. Can you not make use of a web service method that returns data in a compressed fashion after applying security? then you can have a secure and a fast web service.

If you have to get the size, then probably a generalization of Record Count * Column count * average cell size would be adequate to see if the data set is large.

Posted 1-Dec-15 22:47pm

FrancoisViljoen

Comments

[no name] 3-Dec-15 2:03am

Thanks for this reply. can you please explain more about what you said "returns data in a compressed fashion after applying security"? what do you exactly mean by that?

FrancoisViljoen 3-Dec-15 9:34am

Obviously I do not have a complete view of your whole application, but what you can possibly look at doing is to compress the response using a gzip stream and sending it over as a byte[]. The downside to this is that the consumer has to know what the byte[] actually contains and also how to unzip the information.

[no name] 5-Dec-15 3:18am

can you please post some links about gzip?

FrancoisViljoen 5-Dec-15 6:01am

Google GZipStream