You would need to calculate the number of rows, and the amount of data for
each row. If you have strings this will be very difficult. There is also
overhead with internal variables in the object etc.
Not an easy thing to calculate as there is not SizeOf(object as object) as
integer to return this information.
Thank you, what I really need, is to calculate the data transfer from a SQL
Server database, I thought this was less complicated.
I renew my question, is there a simple way to calculate in Kb, the
comunication to a SQL Server?
Thank you again
I guess we need to know what you mean by the KB's for a connection.
There are many resources used depending on how you connect. There will be
objects on the client workstation , a connection and a command. On the
server there will the connection and whatever memory is used for the query
and the query plan.
What is it that you are trying to use this information for?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
