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.