Enable SQL Parsing
|
When
enabled, SQL statements are parsed by NAS and then sent to the database.
If NAS cannot parse the SQL an error is returned. This feature is
useful for developers using generic SQL that interacts with multiple
databases. Use this feature during the testing and staging phases
of application development.
|
Log Debug Messages
|
This
option logs database interaction in detail. To view the messages being
logged, look at the appropriate kjs or kcs engine log. This feature
is useful during testing, staging, and production. You can turn the
option off after an application is successfully launched into production
but you can turn it back on at any time to monitor database interaction. |
Connection Timeout
|
Allows
the administrator to set the amount of time in seconds to wait before
giving up on a request to establish a database connection. If the
indicated time is reached and a connection has not been made, the
request is taken out of the queue. |
Thread Parameters
|
The
database thread parameters determine how many threads NAS allocates
for asynchronous database queries. Each thread uses a small stack
allocation and pulls from the total number of available system threads.
If the developer uses asynchronous queries, increasing the number
of threads can increase performance. Asynchronous threads are not
supported by the JDBC 4.0 interface. Therefore, if the applications
housed on a server do not use any asynchronous queries, you can increase
performance by setting the maximum available threads to zero. |
The database cache
is an array used to hold active and recently used database connections.
While an application is using a database connection, NAS marks the connection
as in use. After the database operations finish, the server marks the
database connection free. The cache then holds the free connection in
the cache for a configured period of time. This allows the server to
reuse the free cached connection and quickly handle a new request to
the same database. After a free connection exceeds the timeout, a cleaning
thread removes the connection from the cache and opens a slot for a
new connection to be cached.