Calculating conversion times accurately is crucial for optimizing workflow and response times in Rendition Server. This article explains how to use SQL SELECT queries to calculate conversion times by leveraging the ArrivalTime and DepartureTime timestamps in the dbo.RequestProtocolItems table of the FoxitRS database.
Instructions:
To accurately measure conversion time, follow these steps:
1. Activate Request Protocol:
Ensure that the Request Protocol is activated in the configuration settings. You can configure this by navigating to:
http://localhost/config/TechnicalConfig
--> Managing Node Configuration Tab
--> Request Protocol Configuration
2. Understand Timestamps:
- <ArrivalTime>: This timestamp marks when a request arrives at the Managing Node.
- <DepartureTime>: This timestamp indicates when the conversion process is completed, and the result is ready for retrieval.
3. Construct the SQL Query:
Use the following SQL query as a template to calculate conversion times:
SELECT
RequestID,
DATEDIFF(millisecond, ArrivalTime, DepartureTime) AS ArrivalToDepartureTime
FROM
dbo.RequestProtocolItems
WHERE
RequestID = [RequestID];
- Replace [RequestID] with the specific Request ID you want to analyze.
4. Interpretation of "ArrivalToDepartureTime":
The calculated "ArrivalToDepartureTime" represents the time difference in milliseconds between the moment of the incoming request and the provision of the result. This value is essential for analyzing the efficiency of the conversion process.
5. Consider "ArrivalToDispatch":
- To determine whether a conversion started immediately or was queued, you can calculate "ArrivalToDispatch" by using ArrivalTime and DispatchTime.
6. Alternative Tracking Methods: For more granular tracking, you can monitor conversion times directly at the request level using the SOAP interface via `GetRequestItems(RequestID)` or the REST interface via `GET /rs/api/rest/conversion/{id}` (which provides Arrival and Departure times).
