Link to this page
Print this page
Parent topic
:
SQL programming
SQL support
/
SQL programming
SQL performance
Performance with dynamic SQL
Comparing static SQL statements and dynamc SQL statements used in a loop.
Performance with transactions
Commit database changes by blocks of transaction speeds performance with some database servers.
Avoiding long transactions
Long transactions consume resources and decrease concurrent data access.
Declaring prepared statements
Optimize prepared cursor statements by using the
FROM
clause of
DECLARE CURSOR
.
Saving SQL resources
SQL cursors and prepared statement consume resources that should be freed when useless.
Optimizing scrollable cursors
A programming pattern to get fresh data from scrollable cursors.