<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns:MadCap="http://www.madcapsoftware.com/Schemas/MadCap.xsd" MadCap:lastBlockDepth="2" MadCap:lastHeight="120" MadCap:lastWidth="624" MadCap:disableMasterStylesheet="true" MadCap:tocPath="Tuning|Main Operations Performance|Delete Performance" MadCap:InPreviewMode="false" MadCap:RuntimeFileType="Topic" MadCap:TargetType="WebHelp" MadCap:PathToHelpSystem="../../../../" MadCap:HelpSystemFileName="index.xml" MadCap:SearchType="Stem">
<head><title>Cascade On Delete </title>
<script type="text/javascript">/* <![CDATA[ */
window.onload = function(){
var pathToFlash = $('html').attr('MadCap:PathToHelpSystem') + 'Content/Resources/Code/ZeroClipboard.swf';
ZeroClipboard.setMoviePath(pathToFlash);
function bindToClipBord(element,content){
var clip = new ZeroClipboard.Client();
clip.setText(content);
clip.glue(element);
};
if(location.protocol==='file:'){
$('.copylink-marker').remove();
} else{
$('.copylink-marker').each(function(){
var text = $(this).parent().parent().children('.prettyprint').html();
$(this).hover(function(){
bindToClipBord(this,text);
},
function(){});
});
}
prettyPrint();
};
/* ]]> */</script>
<link href="../../../SkinSupport/MadCap.css" rel="stylesheet" />
<link href="../../../Resources/Stylesheets/OnlineStyle.css" rel="stylesheet" />
<script src="../../../Resources/Code/prettify.js">
</script>
<script src="../../../Resources/Code/lang-vb.js">
</script>
<script src="../../../Resources/Code/jquery.min.js">
</script>
<script src="../../../Resources/Code/ZeroClipboard.js">
</script>
<script src="../../../SkinSupport/MadCapAll.js" type="text/javascript">
</script>
</head>
<body>
<p class="MCWebHelpFramesetLink" style="display: none;"><a href="../../../../index_CSH.html#tuning/main_operations_performance/delete_performance/cascade_on_delete.htm" style="">Open topic with navigation</a>
</p>
<div class="MCBreadcrumbsBox"><span class="MCBreadcrumbsPrefix">You are here: </span><a class="MCBreadcrumbsLink" href="../../../tuning.htm">Tuning</a><span class="MCBreadcrumbsDivider"> > </span><a class="MCBreadcrumbsLink" href="../../main_operations_performance.htm">Main Operations Performance</a><span class="MCBreadcrumbsDivider"> > </span><a class="MCBreadcrumbsLink" href="../delete_performance.htm">Delete Performance</a><span class="MCBreadcrumbsDivider"> > </span><span class="MCBreadcrumbs">Cascade On Delete</span>
</div>
<p>
<script type="text/javascript">/*<![CDATA[*/document.write('<a href="' + location.href +'">');
document.write("Direct Link");
document.write('</a>');/*]]>*/</script>
</p>
<p>
</p>
<h1><a name="kanchor115"></a>Cascade On Delete</h1>
<p>
</p>
<p>If you are using cascadeOnDelete option and explicit deletion
of one object causes cascaded delete on several others, you may expect slower
execution:</p>
<p MadCap:conditions="Global.Primary:java" />
<p>Note that in the first part of the test each object
deletion only includes a single object. Therefore, when we delete a 1000
objects the amount of the objects in the database is 1000 less. In the second
part each object deletion will trigger deletion of all field objects
(cascadeOnDelete option), therefore the amount of objects deleted from the
database can be anywhere between 1000 (only lowest level objects) and 3000(all
top level objects with their field objects).</p>
<p><i>The results from the test machine:</i>
</p>
<p><i>Delete test with
objects of different depth</i>
</p>
<p><i>Deleting 1000 of
10000 objects with 1 levels of embedded objects:</i>
</p>
<p><i>Store 10000
objects: 528ms</i>
</p>
<p><i>Amount of
objects left: 10000</i>
</p>
<p><i>Deleted 1000
objects in: 197 ms.</i>
</p>
<p><i>Amount of
objects left: 9000</i>
</p>
<p><i>Deleting 1000 of
10000 objects with 3 levels of embedded objects:</i>
</p>
<p><i>Store 30000
objects: 1693ms</i>
</p>
<p><i>Amount of
objects left: 39000</i>
</p>
<p><i>Deleted 1000
objects in: 340 ms.</i>
</p>
<p><i>Amount of
objects left: 36978</i>
</p>
<script type="text/javascript" src="../../../SkinSupport/MadCapBodyEnd.js">
</script>
</body>
</html>
