59 lines
3.7 KiB
HTML
59 lines
3.7 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="reference" />
|
||
|
|
<meta name="DC.Title" content="Decide DRDA data location" />
|
||
|
|
<meta name="abstract" content="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." />
|
||
|
|
<meta name="description" content="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." />
|
||
|
|
<meta name="DC.subject" content="data location, deciding, performance, deciding data location" />
|
||
|
|
<meta name="keywords" content="data location, deciding, performance, deciding data location" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1improveviadata.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="rbal1decdrda" />
|
||
|
|
<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>Decide DRDA data
|
||
|
|
location</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbal1decdrda"><a name="rbal1decdrda"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Decide DRDA<sup>®</sup> data
|
||
|
|
location</h1>
|
||
|
|
<div><p>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.</p>
|
||
|
|
<div class="section"><ul><li>Transactions that use the data</li>
|
||
|
|
<li>How often the transactions are performed</li>
|
||
|
|
<li>How much data the transactions send or receive</li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>If an application involves transactions that run frequently or
|
||
|
|
that send or receive a lot of data, you should try to keep it in the same
|
||
|
|
location as the data. For example, an application that runs many times a
|
||
|
|
second or that receives hundreds of rows of data at a time will have better
|
||
|
|
performance if the application and data are on the same server. Conversely,
|
||
|
|
consider placing data in a different location than the application that needs
|
||
|
|
it if the application includes low-use transactions or transactions that send
|
||
|
|
or receive only moderate amounts of data at a time.</p>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal1improveviadata.htm" title="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.">Improve distributed relational database performance through the database</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|