Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\sqlserv.15.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/sqlserv.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="sqlserv.15.01.html#180913">11 The SQL Server Wire Protocol Driver</a> : Performance Considerations</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="180913">Performance Considerations</a></div> <div class="Body"><a name="289008">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="289020">Connection Pooling (ConnectionPooling)</a></span>: If you enable the driver to use connection pooling, you can set additional options that affect performance:</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"><span class="Action_bold"><a name="289021">Load Balance Timeout</a></span>: You can define how long to keep connections in the pool. The time that a connection was last used is compared to the current time and, if the timespan exceeds the value of the Load Balance Timeout option, the connection is destroyed. The Min Pool Size option can cause some connections to ignore this value.</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"><span class="Action_bold"><a name="289022">Connection Reset</a></span>: Resetting a re-used connection to the initial configuration settings impacts performance negatively because the connection must issue additional commands to the server.</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"><span class="Action_bold"><a name="289023">Max Pool Size</a></span>: Setting the maximum number of connections that the pool can contain too low might cause delays while waiting for a connection to become available. Setting the number too high wastes resources.</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"><span class="Action_bold"><a name="289024">Min Pool Size</a></span>: A connection pool is created when the first connection with a unique connection string connects to the database. The pool is populated with connections up to the minimum pool size, if one has been specified. The connection pool retains this number of connections, even when some connections exceed their Load Balance Timeout value.</div> </td> </tr> </table> </div> <div class="Body"><span class="Action_bold"><a name="289028">Enable Bulk Load (EnableBulkLoad)</a></span>: If your application performs bulk loading of data, you can improve performance by configuring the driver to use the database system's bulk load functionality instead of database array binding. The trade-off to consider for improved performance is that using the bulk load functionality can bypass data integrity constraints.</div> <div class="Body"><span class="Action_bold"><a name="289036">Encryption Method </a></span><span class="Bold_Note_Etc">(</span><span class="Action_bold">EncryptionMethod</span><span class="Bold_Note_Etc">)</span>: Data encryption may adversely affect performance because of the additional overhead (mainly CPU usage) that is required to encrypt and decrypt data.</div> <div class="Body"><span class="Action_bold"><a name="289040">Failover Mode (FailoverMode)</a></span>: Although high availability that replays queries after a failure provides increased levels of protection, it can adversely affect performance because of increased overhead.</div> <div class="Body"><span class="Action_bold"><a name="289044">Packet Size</a></span><span class="Bold_Note_Etc"> (</span><span class="Action_bold">PacketSize</span><span class="Bold_Note_Etc">)</span>: Typically, it is optimal for the client to use the maximum packet size that the database server allows. This reduces the total number of round trips required to return data to the client, thus improving performance. Therefore, performance can be improved if the PacketSize attribute is set to the maximum packet size of the server.</div> <div class="Body"><span class="Action_bold"><a name="289048">Use Snapshot Transactions (SnapshotSerializable)</a></span>: You must have your Microsoft SQL Server 2005 and higher database configured for snapshot isolation for this connection option to work. Snapshot Isolation provides transaction-level read consistency and an optimistic approach to data modifications by not acquiring locks on data until data is to be modified. This Microsoft SQL Server 2005 and higher feature can be useful if you want to consistently return the same result set even if another transaction has changed the data and 1) your application executes many read operations or 2) your application has long running transactions that could potentially block users from reading data. This feature has the potential to eliminate data contention between read operations and update operations. When this connection option is enabled, performance is improved due to increased concurrency.</div> <div class="Body"><a name="188737">See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlserv.15.10.html#189825', '');">â??Using The Snapshot Isolation Levelâ??</a></span> for details.</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