    Performance Tuning
    Page edited by             Van Halbert

        Comment:
        Added an introduction as to where all the properties can be found

                         Changes (2)

            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: 

{code} 
/subsystem=teiid:read-resource-description 
{code} 

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" 
# 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: 

{code} 
/subsystem=teiid/transport={jdbc | odbc | embedded}:read-resource-description 
{code} 

                            Full Content

        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:

/subsystem=teiid:read-resource-description

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"
	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

                        Stop watching space
            |
                Change email notification preferences

        View Online
        |
        View Changes
                |
        Add Comment