Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\oraclecli.17.05.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>Performance Considerations</title> <link rel="StyleSheet" href="css/oraclecli.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="oraclecli.17.01.html#558790">13 The Oracle Driver </a> : Performance Considerations</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="558790">Performance Considerations</a></div> <div class="Body"><a name="608704">The following connection options can enhance driver performance. You can also enhance </a>performance through efficient application design. Refer to<span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'design.07.1.html#106796', '');"> </a></span><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'design.07.1.html#106796', '');">Chapter 5 â??Designing ODBC Applications for Performance Optimizationâ?? </a></span>in the <span class="Emphasis">DataDirect Connect Series </span><span class="forbody">for</span> <span class="Emphasis" style="font-size: 8.0pt;">ODBC</span><span class="Emphasis" style="font-size: 10.0pt;"> </span><span class="Emphasis" style="font-size: 10.0pt;">Reference</span> for details.</div> <div class="Body"><span class="Action_bold"><a name="608716">Application Using Threads (ApplicationUsingThreads)</a></span>: The driver coordinates concurrent database operations (operations from different threads) by acquiring locks. Although locking prevents errors in the driver, it also decreases performance. If your application does not make ODBC calls from different threads, the driver has no reason to coordinate operations. In this case, the ApplicationUsingThreads attribute should be disabled (set to 0).</div> <div class="Body"><a name="608717">NOTE: If you are using a multi-threaded application, you must enable the Application Using </a>Threads option.</div> <div class="Body"><span class="Action_bold"><a name="608721">Array Size</a></span><span class="Bold_Note_Etc"> (ArraySize)</span>: If this connection string attribute is set appropriately, the driver can improve performance of your application by reducing the number of round trips on the network. For example, if your application normally retrieves 200 rows, it is more efficient for the driver to retrieve 200 rows at one time over the network than to retrieve 50 rows at a time during four round trips over the network.</div> <div class="Body"><span class="Action_bold"><a name="608725">Catalog Functions Include Synonyms (CatalogIncludesSynonyms)</a></span>: Standard ODBC behavior is to include synonyms in the result set of calls to the following catalog functions: SQLProcedures, SQLStatistics and SQLProcedureColumns. Retrieving this synonym information degrades performance. If your ODBC application does not need to return synonyms when using these catalog functions, the driver can improve performance if the CatalogIncludesSynonyms attribute is disabled (set to 0).</div> <div class="Body"><span class="Action_bold"><a name="608729">Catalog Options (CatalogOptions)</a></span>: If your application does not need to access the comments/remarks for database tables, performance of your application can be improved. In this case, the CatalogOptions attribute should be disabled (set to 0) because retrieving comments/remarks degrades performance. If this attribute is enabled (set to 1), result column REMARKS (for the catalog functions SQLTables and SQLColumns) and the result column COLUMN_DEF (for the catalog function SQLColumns) return actual values.</div> <div class="Body"><span class="Action_bold"><a name="608733">Default Buffer Size for Long/LOB Columns (DefaultLongDataBuffLen)</a></span>: To improve performance when your application fetches images, pictures, or long text or binary data, a buffer size can be set to accommodate the maximum size of the data. The buffer size should only be large enough to accommodate the maximum amount of data retrieved; otherwise, performance is reduced by transferring large amounts of data into an oversized buffer. If your application retrieves more than 1 MB of data, the buffer size should be increased accordingly.</div> <div class="Body"><span class="Action_bold"><a name="608737">Describe At Prepare</a></span><span class="Bold_Note_Etc"> (</span><span class="Action_bold">DescribeAtPrepare</span><span class="Bold_Note_Etc">)</span>: When enabled, this option requires extra network traffic. If your application does not require result set information at prepare time (for instance, you request information about the result set using SQLColAttribute(s), SQLDescribeCol, SQLNumResultCols, and so forth, before calling SQLExecute on a prepared statement), you can increase performance by disabling this option.</div> <div class="Body"><span class="Action_bold"><a name="608741">Enable Scrollable Cursors (EnableScrollableCursors) </a></span>and<span class="Action_bold"> Enable Static Cursors for </span><span class="Action_bold">Long Data</span><span class="Bold_Note_Etc"> (</span><span class="Action_bold">EnableStaticCursorsForLongData</span><span class="Bold_Note_Etc">)</span>: When your application uses Static or Keyset (Scrollable) cursors, the EnableScrollableCursors attribute must be enabled (set to 1). Also, if your application retrieves images, pictures, long text or binary data while using Static cursors, the EnableStaticCursorsForLongData attribute must be enabled (set to 1). However, this can degrade performance when retrieving long data with Static cursors as the entire result set is stored on the client. To improve performance, you might consider designing your application to retrieve long data through forward-only cursors.</div> <div class="Body"><span class="Bold_Note_Etc"><a name="608745">Lock Timeout (LockTimeOut)</a></span>: Sometimes users attempt to select data that is locked by another user. Oracle provides three options when accessing locked data with SELECT â?¦ FOR UPDATE statements:</div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="608746">Wait indefinitely for the lock to be released (-1)</a></div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="608747">Return an error immediately (0)</a></div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="608748">Return an error if the lock has not been released within a specific number of seconds (</a><span class="Emphasis">n</span> seconds)</div> </td> </tr> </table> </div> <div class="Body_Indent"><a name="608749">NOTE: This option is not available with Oracle 8.</a></div> <div class="Body"><a name="608750">Some applications may benefit by not waiting indefinitely and continuing execution; this </a>keeps the application from hanging. The application, however, needs to handle lock timeouts properly with an appropriate timeout value; otherwise, processing time could be wasted handling lock timeouts, and deadlocks could go undetected.</div> <div class="Body"><a name="608751">To improve performance, either enter a number of seconds or enter 0 as the value for this </a>option.</div> <div class="Body"><span class="Action_bold"><a name="558842">Optimize Long Performance (OptimizeLongPerformance)</a></span>: When enabled, this option fetches Long data directly into the application's buffers rather than allocating buffers and making a copy. Also, when enabled, this option decreases fetch times on Long data; however, it can cause the application to be limited to one active statement per connection.</div> <div class="Body"><span class="Action_bold"><a name="608755">Procedure Returns Results (ProcedureRetResults)</a></span>: The driver can be tuned for improved performance if your application's stored procedures do not return results. In this case, the ProcedureRetResults attribute should be disabled (set to 0).</div> <div class="Body"><span class="Action_bold"><a name="608759">Use Current Schema for SQLProcedures (UseCurrentSchema)</a></span>: If your application needs to access database objects owned only by the current user, performance of your application can be improved. In this case, the UseCurrentSchema attribute should be enabled (set to 1). When this attribute is enabled, the driver returns only database objects owned by the current user when executing catalog functions. Calls to catalog functions are optimized by grouping queries. Enabling this attribute is equivalent to passing the Logon ID used on the connection as the SchemaName argument to the catalog functions.</div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de