Using XSQLConfig.xml to Tune Your Environment

Use the XSQLConfig.xml File to tune your environment for working with XSQL Servlet. Parameters you can configure for your environment within the XSQLConfig.xml file include the following:

• The default number of records to fetch per database round-trip for <xsql:query> actions.

• Size (in pages) of the XSQL Page LRU cache.

• Size (in stylesheets) of the XSLT Stylesheet LRU cache.

• Size (in bytes) of the Buffered Output Stream to use for XSQL Servlet (or zero to disable)

• Initial and increment size of the connection pool, as well as the time-out threshold (in seconds) for cleaning up connections.

• Initial and increment size of the XSLT Stylesheet pool, as well as the time-out threshold (in seconds) for cleaning up stylesheet instances.

• MIME types for which to suppress setting character-set information.

Modifying XSQL Configuration Settings

XSQL Page Processor loads the first XSQLConfig.xml file that it can find in the CLASSPATH of the environment in which it is running. XSQLConfig.xml file contains configuration parameters that affect how XSQL Page Processor and XSQL Servlet work. Each configuration parameter is documented in comments before it in the XSQLConfig.xml file. By default, the XSQLConfig.xml file is located at ./xsql/lib.