Administration and Programming Guide for OS/390
In the sections that follow, some performance techniques about the SQL
language environment are described. To learn about DB2 performance
considerations, visit the web at:
http://review.ibm.com/software/data/db2/performance
Use the following SQL language environment techniques to improve
performance.
- Use the START_ROW_NUM and RPT_MAX_ROWS Net.Data variables to reduce
the size of returned tables. If a result set contains a large number of
rows, you can specify a subset of the result set that is returned to the
browser by using START_ROW_NUM and RPT_MAX_ROWS. START_ROW_NUM
specifies the row number of the first row to return, and RPT_MAX_ROWS
specifies the number of rows to return.
Important: | Net.Data reissues the query for every request because cursor position
is not maintained across requests.
|
- Consider calling a stored procedure that uses static SQL. Dynamic
SQL is prepared at run time, while static SQL is prepared at the precompile
stage. The SQL language environment uses dynamic SQL, which allows it
to run SQL statements at program run time. Because preparing statements
requires additional processing time, static SQL is more efficient.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]