Avoid Data Type Conversions
TimesTen instruction paths are so short that even small delays due to data conversion can cause a relatively large percentage increase in transaction time.
To avoid data type conversions:
-
Match input argument types to expression types.
-
Match the types of output buffers to the types of the fetched values.
-
Match the connection character set to the database character set.