7.3.5 Operands related to buffers

16) pd_sql_object_cache_size = SQL-object-buffer-size
[Figure]<unsigned integer> (KB)
  • 32-bit mode: ((22-256000))
  • 64-bit mode: ((22-2000000))
Specifies in kilobytes the size of the buffer area (shared memory) in which SQL objects are to be placed.
Specification guidelines
  • SQL objects are saved in a buffer until the user's transaction has terminated. The buffer must be large enough to store the SQL objects of all transactions that will be executed concurrently.
  • SQL analysis can be reduced by saving the SQL objects of static SQLs in the buffer after transaction termination (until the buffer runs out of space) and sharing them among multiple users who execute the same UAP. To effectively utilize the buffer, it should be allocated so that the SQL objects of frequently-used UAPs are resident in the buffer.
  • To estimate the buffer size, first determine the buffer size needed for UAP execution from the length of the SQL objects from the SQL statements to be issued by the UAP. Then, compute the buffer size by considering the number of UAPs that will be executed concurrently and the number of concurrently executing users.
  • For details about how to estimate the length of the SQL object from a single SQL statement, see D.2 Formulas for determining size of SQL object buffer (pd_sql_object_cache_size).
Tuning the specified value
For details about how to tune the SQL object buffer size, see the HiRDB Version 8 System Operation Guide.