Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Performance GuideThe HCL OneDB™ Performance Guide describes how to configure and operate your HCL OneDB™ database server to improve overall system throughput and to improve the performance of SQL queries.
Performance basicsPerformance measurement and tuning issues and methods are relevant to daily database server administration and query execution.
Measurements of performanceYou can use throughput, response time, cost per transaction, and resource utilization measures to evaluate performance.
Response timeResponse time measures the performance of an individual transaction or query. Response time is typically treated as the elapsed time from the moment that a user enters a command or activates a function until the time that the application indicates that the command or function has completed.
Response-time measurementTo measure the response time for a query or application, you can use the timing commands and performance monitoring and timing functions that your operating system provides.
Timing functions within your applicationMost programming languages have a library function for the time of day. If you have access to the source code, you can insert pairs of calls to this function to measure the elapsed time between specific actions.

Timing functions within your application

Most programming languages have a library function for the time of day. If you have access to the source code, you can insert pairs of calls to this function to measure the elapsed time between specific actions.

ESQL/C Only: For example, if the application is written in , you can use the dtcurrent() function to obtain the current time. To measure response time, you can call dtcurrent() to report the time at the start of a transaction and again to report the time when the transaction commits.

Elapsed time, in a multiprogramming system or network environment where resources are shared among multiple processes, does not always correspond to execution time. Most operating systems and C libraries contain functions that return the CPU time of a program.