Post reply

Size of Data Returned from View or Query

  • June 9, 2006 at 7:36 am

    #114398

    We are programming a Webservicesapp that will be returning data to remote users. We've written a lot of views that are called from this app. We are trying to tweak performance so we want to see what the size of the data is that our view/s are returning. Is this possible?

     

  • June 9, 2006 at 7:46 am

    #642789

    (sum of DATALENGTH for all columns) multiplied with the number of rows gives a rough estimate of the amount of data sent.

    N 56°04'39.16"
    E 12°55'05.25"

  • June 9, 2006 at 8:46 am

    #642821

    Thanks Peter. I did that with all the columns from view. Seems to work well. Thanks again.

     

    select

    sum(datalength(col1))+sum(datalength(col2)) as DataSize from v_View1

  • June 9, 2006 at 9:54 am

    #642847

    You're welcome.

    N 56°04'39.16"
    E 12°55'05.25"

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply