<?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|Insert Performance" MadCap:InPreviewMode="false" MadCap:RuntimeFileType="Topic" MadCap:TargetType="WebHelp" MadCap:PathToHelpSystem="../../../../" MadCap:HelpSystemFileName="index.xml" MadCap:SearchType="Stem">
<head><title>Object Structure </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/insert_performance/object_structure.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="../insert_performance.htm">Insert Performance</a><span class="MCBreadcrumbsDivider"> > </span><span class="MCBreadcrumbs">Object Structure</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>Object Structure</h1>
<p>Object Structure naturally has a major influence on insert
performance: inserting one object, which is a linked list of 1000 members, is
much slower than inserting an object with a couple of primitive fields.</p>
<p>The following test compares storing time of similar objects
with one different field:</p>
<p MadCap:conditions="Global.Primary:java" />
<p MadCap:conditions="Primary..NET">
<pre class="prettyprint" xml:space="preserve">InsertPerformanceBenchmark.cs: RunDifferentObjectsTest
private void RunDifferentObjectsTest()
{
Configure();
Init();
System.Console.WriteLine("Storing " + _count + " objects with "
+ _depth + " levels of embedded objects:");
Clean();
System.Console.WriteLine(" - primitive object with int field");
Open();
StoreSimplest();
Close();
Open();
System.Console.WriteLine(" - object with String field");
Store();
Close();
Clean();
Open();
System.Console.WriteLine(" - object with StringBuilder field");
StoreWithStringBuilder();
Close();
Clean();
Open();
System.Console.WriteLine(" - object with int array field");
StoreWithArray();
Close();
Clean();
Open();
System.Console.WriteLine(" - object with ArrayList field");
StoreWithArrayList();
Close();
}</pre>
<pre class="prettyprint" xml:space="preserve">InsertPerformanceBenchmark.cs: Configure
private void Configure()
{
IConfiguration config = Db4oFactory.Configure();
config.LockDatabaseFile(false);
config.WeakReferences(false);
config.Io(new MemoryIoAdapter());
config.FlushFileBuffers(false);
}</pre>
<pre class="prettyprint" xml:space="preserve">InsertPerformanceBenchmark.cs: Init
private void Init()
{
_count = 10000;
_depth = 3;
_isClientServer = false;
}</pre>
<pre class="prettyprint" xml:space="preserve">InsertPerformanceBenchmark.cs: StoreSimplest
private void StoreSimplest()
{
StartTimer();
for (int i = 0; i < _count; i++)
{
SimplestItem item = new SimplestItem(i, null);
for (int j = 1; j < _depth; j++)
{
item = new SimplestItem(i, item);
}
objectContainer.Store(item);
}
objectContainer.Commit();
StopTimer("Store " + TotalObjects() + " objects");
}</pre>
<pre class="prettyprint" xml:space="preserve">InsertPerformanceBenchmark.cs: Store
private void Store()
{
StartTimer();
for (int i = 0; i < _count; i++)
{
Item item = new Item("load", null);
for (int j = 1; j < _depth; j++)
{
item = new Item("load", item);
}
objectContainer.Store(item);
}
objectContainer.Commit();
StopTimer("Store " + TotalObjects() + " objects");
}</pre>
<pre class="prettyprint" xml:space="preserve">InsertPerformanceBenchmark.cs: StoreWithStringBuilder
private void StoreWithStringBuilder()
{
StartTimer();
for (int i = 0; i < _count; i++)
{
ItemWithStringBuilder item = new ItemWithStringBuilder(
new StringBuilder("load"), null);
for (int j = 1; j < _depth; j++)
{
item = new ItemWithStringBuilder(new StringBuilder("load"), item);
}
objectContainer.Store(item);
}
objectContainer.Commit();
StopTimer("Store " + TotalObjects() + " objects");
}</pre>
<pre class="prettyprint" xml:space="preserve">InsertPerformanceBenchmark.cs: StoreWithArray
private void StoreWithArray()
{
StartTimer();
int[] array = new int[] { 1, 2, 3, 4 };
for (int i = 0; i < _count; i++)
{
int[] id = new int[] { 1, 2, 3, 4 };
ItemWithArray item = new ItemWithArray(id, null);
for (int j = 1; j < _depth; j++)
{
int[] id1 = new int[] { 1, 2, 3, 4 };
item = new ItemWithArray(id1, item);
}
objectContainer.Store(item);
}
objectContainer.Commit();
StopTimer("Store " + TotalObjects() + " objects");
}</pre>
<pre class="prettyprint" xml:space="preserve">InsertPerformanceBenchmark.cs: StoreWithArrayList
private void StoreWithArrayList()
{
StartTimer();
ArrayList idList = new ArrayList();
idList.Add(1);
idList.Add(2);
idList.Add(3);
idList.Add(4);
for (int i = 0; i < _count; i++)
{
ArrayList ids = new ArrayList();
ids.AddRange(idList);
ItemWithArrayList item = new ItemWithArrayList(ids, null);
for (int j = 1; j < _depth; j++)
{
ArrayList ids1 = new ArrayList();
ids1.AddRange(idList);
item = new ItemWithArrayList(ids1, item);
}
objectContainer.Store(item);
}
objectContainer.Commit();
StopTimer("Store " + TotalObjects() + " objects");
}</pre>
<pre class="prettyprint" xml:space="preserve">InsertPerformanceBenchmark.cs: SimplestItem
public class SimplestItem
{
public int _id;
public SimplestItem _child;
public SimplestItem()
{
}
public SimplestItem(int id, SimplestItem child)
{
_id = id;
_child = child;
}
}</pre>
<pre class="prettyprint" xml:space="preserve">InsertPerformanceBenchmark.cs: ItemWithArray
public class ItemWithArray
{
public int[] _id;
public ItemWithArray _child;
public ItemWithArray()
{
}
public ItemWithArray(int[] id, ItemWithArray child)
{
_id = id;
_child = child;
}
}</pre>
<pre class="prettyprint" xml:space="preserve">InsertPerformanceBenchmark.cs: ItemWithArrayList
public class ItemWithArrayList
{
public ArrayList _ids;
public ItemWithArrayList _child;
public ItemWithArrayList()
{
}
public ItemWithArrayList(ArrayList ids, ItemWithArrayList child)
{
_ids = ids;
_child = child;
}
}</pre>
<pre class="prettyprint" xml:space="preserve">InsertPerformanceBenchmark.cs: ItemWithStringBuilder
public class ItemWithStringBuilder
{
public StringBuilder _name;
public ItemWithStringBuilder _child;
public ItemWithStringBuilder()
{
}
public ItemWithStringBuilder(StringBuilder name, ItemWithStringBuilder child)
{
_name = name;
_child = child;
}
}</pre>
</p>
<p MadCap:conditions="Global.Primary:net" />
<p>The following results were achieved for the
<a href="../insert_performance.htm">testing configuration</a>:</p>
<p MadCap:conditions="Global.Primary:java" />
<p MadCap:conditions="Primary..NET">
<p>.NET:</p>
<p>Storing 10000 objects with 3 levels of embedded objects:</p>
<p> - primitive object
with int field</p>
<p>Store 30000 objects: 1123ms</p>
<p> - object with String
field</p>
<p>Store 30000 objects: 1356ms</p>
<p> - object with
StringBuilder field</p>
<p>Store 30000 objects: 4982ms</p>
<p> - object with int
array field</p>
<p>Store 30000 objects: 1810ms</p>
<p> - object with
ArrayList field</p>
<p>Store 30000 objects: 3479ms</p>
</p>
<p MadCap:conditions="Global.Primary:net" />
<p MadCap:conditions="Primary.Online">Download example code:</p>
<p MadCap:conditions="Primary.Online">
<MadCap:conditionalText MadCap:conditions="Primary..NET,Primary.c#,Primary.All languages"><a href="../performancecs.zip">c# </a>
</MadCap:conditionalText>
</p>
<script type="text/javascript" src="../../../SkinSupport/MadCapBodyEnd.js">
</script>
</body>
</html>
