/subsystem=teiid:read-resource-description
Performance Tuning
Performance tuning can be done by changing the property settings defined in the teiid subsystem and its sub components.
Execute the following command on CLI to see the possible settings at the root of the teiid subsystem:
There are several categories of properties:
-
Memory Management
-
BufferManager: all properties that start with "buffer-service"
-
Cache Tuning: all properties that start with "resultset-cache" or "preparedplan-cache"
-
Threading
-
LOBs
-
Other Considerations
Socket Transport settings for one of the supported transport types (i.e., jdbc, odbc, embedded) can be viewed by executing the following command:
/subsystem=teiid/transport={jdbc | odbc | embedded}:read-resource-description