60 lines
4.8 KiB
HTML
60 lines
4.8 KiB
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 lang="en-us" xml:lang="en-us">
|
|
<head>
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
|
<meta name="security" content="public" />
|
|
<meta name="Robots" content="index,follow" />
|
|
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
|
|
<meta name="DC.Type" content="concept" />
|
|
<meta name="DC.Title" content="Improve distributed relational database performance through the database" />
|
|
<meta name="abstract" content="Distributed relational database performance is affected by the overall design of the database. The location of distributed data, the level of commitment control you use, and the design of your SQL indexes all affect performance." />
|
|
<meta name="description" content="Distributed relational database performance is affected by the overall design of the database. The location of distributed data, the level of commitment control you use, and the design of your SQL indexes all affect performance." />
|
|
<meta name="DC.subject" content="performance, improving through database, database, improving performance through" />
|
|
<meta name="keywords" content="performance, improving through database, database, improving performance through" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1perform.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1decdrda.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1facblk.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1factor.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1plan.htm" />
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" />
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1998, 2006" />
|
|
<meta name="DC.Format" content="XHTML" />
|
|
<meta name="DC.Identifier" content="rbal1improveviadata" />
|
|
<meta name="DC.Language" content="en-us" />
|
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
|
<!-- US Government Users Restricted Rights -->
|
|
<!-- Use, duplication or disclosure restricted by -->
|
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
|
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
|
|
<link rel="stylesheet" type="text/css" href="./ic.css" />
|
|
<title>Improve distributed relational database performance through the database</title>
|
|
</head>
|
|
<body id="rbal1improveviadata"><a name="rbal1improveviadata"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">Improve distributed relational database performance through the database</h1>
|
|
<div><p>Distributed relational database performance is affected by the
|
|
overall design of the database. The location of distributed data, the level
|
|
of commitment control you use, and the design of your SQL indexes all affect
|
|
performance.</p>
|
|
</div>
|
|
<div>
|
|
<ul class="ullinks">
|
|
<li class="ulchildlink"><strong><a href="rbal1decdrda.htm">Decide DRDA data location</a></strong><br />
|
|
Because putting a network between an application and the data it needs will probably slow performance, consider these items when deciding where to put data.</li>
|
|
<li class="ulchildlink"><strong><a href="rbal1facblk.htm">Factors that affect blocking for DRDA</a></strong><br />
|
|
A very important performance factor is whether blocking occurs when data is transferred between the application requester (AR) and the application server (AS). A group of rows transmitted as a block of data requires much less communications overhead than the same data sent one row at a time.</li>
|
|
<li class="ulchildlink"><strong><a href="rbal1factor.htm">Factors that affect the size of DRDA query blocks</a></strong><br />
|
|
If a large amount of data is being returned on a query, performance might be improved by increasing the size of the block of query data. How this is done depends on the types of servers participating in the query.</li>
|
|
</ul>
|
|
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal1perform.htm" title="No matter what kind of application programs you are running on a server, performance can always be a concern. For a distributed relational database, network, server, and application performance are all crucial.">Performance</a></div>
|
|
</div>
|
|
<div class="relconcepts"><strong>Related concepts</strong><br />
|
|
<div><a href="rbal1plan.htm" title="The first requirement for the successful operation of a distributed relational database is thorough planning. You must consider the needs and goals of your enterprise when making the decision to use a distributed relational database.">Planning and design</a></div>
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html> |