does SAP take advantage of prepared statement usage, some db's only simulate the ODBC calls and do not take advantage of the binding. Trying to decide if all the execute directs should be replaced and what possible benefit. Thanks
SAP DB does make use of prepared statements. And given the high overhead for parsing, using them is quite important for performance. In the current version, it is advisable to keep them around for as long as possible. Executing them only once will actually slow things down as one to two additional network requests are required for creating and dropping the statement.
The kernel in the current development tree adds an intersession statement cache (shared SQL).
Future versions of the programming interfaces will add a client side cache (already implemented in the JDBC driver). This removes the additional network requests mentioneed above.
Daniel Dittmar
-- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
