RAS Behavior

To better understand what is happening when a remote user requests data, let us consider a worst-case scenario. Our demo query is simply:

Select count(Published) from TITLES where AuthorState ='WA'

The table TITLES is assumed to have the following characteristics:

• 1024-byte records
• 20,000 records
• No index on AuthorState

This table must be searched record by record to obtain the count.

We will examine a variety of measures when we examine what happens with RAS. The measures are:

• Query transmission size: The number of bytes sent over the connection to start the query.
• Processing transmission size: The number of bytes sent over the connection to determine the result set of the query.
• Processing time on server: Actual time to do the query once the data is obtained.
• Result's transmission size: The number of bytes sent over the connection to return the result set.
• Latency: The time it takes a packet of information to traverse the network.
• Elapsed time: The time from the start of the query to the time that the remote PC receives the last of the query results.