Icon TEDBServerTrace

Unit: edbcomps

TEDBServerTrace = record SessionVersion: Currency; SessionBuild:
      Integer; SessionType: String; SessionAddress: String;
      SessionProcessName: String; SessionName: String;
      SessionDescription: String; SessionThreadID: Integer;
      SessionEncrypted: Boolean; DateTime: TDateTime; ElapsedTime:
      TEDBLongWord; Compression: Integer; FunctionCode: Integer;
      FunctionName: String; ResultCode: Integer; ResultElapsedTime:
      TEDBLongWord; Size: Integer; Info: String; end

This type is used as a parameter to the TEDBEngine OnServerTrace event. The fields of the record are as follows:

FieldDescription
SessionVersionIndicates the ElevateDB version being used by the remote session.
SessionBuildIndicates the ElevateDB build number being used by the remote session.
SessionTypeIndicates the ElevateDB product type being used by the remote session.
SessionAddressIndicates the IP address of the remote session.
SessionProcessNameIndicates the process name of the remote session.
SessionNameIndicates the name (ID) of the remote session.
SessionDescriptionIndicates the description of the remote session.
SessionThreadIDIndicates the thread ID of the remote session.
SessionEncryptedIndicates whether the remote session is using an encrypted connection.
DateTimeIndicates the date and time of the request/response.
ElapsedTimeIndicates the total elapsed time in milliseconds for the request/response.
CompressionIndicates the current compression level for the request/response. This value normally ranges from 0 (no compression) to 9 (best compression), but in some cases may actually appear in the trace record as values greater than or equal to 10. In these cases, the compression has been adjusted by the engine due to the size of the data being too small (less than 1024 bytes). The adjusted compression level can be found by doing this calculation:

Compression mod 10

And the original compression level before the adjustment can be found by using the following calculation:

Compression div 10

Any adjustments to the compression such as this are active for the current request/response only and do not persist any further.
FunctionCodeIndicates the function ID of the request.
FunctionNameIndicates the function name of the request.
ResultCodeIndicates the result code of the request/response. If this value is -1, then the trace record represents a request. Any 0 or higher value indicates that the trace record is a response. You can use this field to determine whether the trace record is for a request (-1) or a response (0 or higher).
SizeIndicates the request/response size, in bytes.
InfoIndicates any additional information about the request, such as the SQL being prepared or executed, or the name of a table being opened.
Image