Archive
Archive for June 8, 2012
Understand Response Time vs. Total Time in SQL
June 8, 2012
Leave a comment
Response time is the time it takes for a query to return the first record. Total time is the time it takes for the query to return all records. For an interactive application, response time is important because it is the perceived time for the user to receive visual affirmation that a query is being processed. For a batch application, total time reflects the overall throughput. You have to determine what the performance criteria are for your application and queries, and then design accordingly.
Categories: SQL, SQL Server
#Responce Time, #SQL, #Total Time, query, response time, sql server