Home |
Previous Page | Next Page Improving Application Performance >
Consider the following when using prepared SQL queries:
- SQLExecDirect is optimized for a single execution of an SQL
statement. Thus it should be used for SQL queries that are not executed
repeatedly.
- In cases where SQL queries are executed multiple times, using
SQLPrepare and SQLExecute improves performance. Typically, you can
do this with input and output parameters.
- SPL routines can be called from an ODBC application to perform
certain SQL tasks and to expand what you can accomplish with SQL
alone. Because SPL is native to the database and SPL routines are
parsed and optimized at creation, rather than at runtime, SPL routines
can improve performance for some tasks. SPL routines can also reduce
traffic between a client application and the database server and
reduce program complexity.
Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]