RE: [bdbxml] Adding XML documents slows down when the container contains large number of documents[#14407]

"Younger Wang" <[email protected]> Mon, 17 Apr 2006 14:04:42 +0800
Newsgroups gmane.comp.db.dbxml.general
Message-ID <002c01c661e4$d451db90$1664640a@younger> 
------=_NextPart_000_002D_01C66227.E2751B90
Content-Type: text/plain;
	charset="gb2312"
Content-Transfer-Encoding: quoted-printable

Stupid me!  I used XPath to specify the node. The right way is =A1=B0 =
addindex
"" ModelID edge-element-equality-string =A1=B1=20

=20

BR

Younger Wang

=20

  _____ =20

From: Younger Wang [mailto:[email protected]]=20
Sent: 2006=C4=EA4=D4=C217=C8=D5 12:59
To: [email protected]
Subject: RE: [bdbxml] Adding XML documents slows down when the container
contains large number of documents[#14407]

=20

Hi,

=20

I think I have found the cause. Before adding a new document, my program
queries against the database. Since I haven=A1=AFt created any index, =
the query
takes a very long time when the database becomes large.=20

=20

Now I have another question. In my XML documents, namespace is not =
declared.
When I add an index, which namespace shall I use? I added index like =
=A1=B0
addindex "" CPEInfo/ModelID edge-element-equality-string =A1=B0, but the =
query
plan showed the index was invalid for =A1=B0
collection("cpeinfo.dbxml")/CPEInfo/ModelID =A1=B1

=20

BR

Younger Wang

=20

=20

  _____ =20

From: Younger Wang [mailto:[email protected]]=20
Sent: 2006=C4=EA4=D4=C217=C8=D5 12:51
To: [email protected]
Subject: RE: [bdbxml] Adding XML documents slows down when the container
contains large number of documents[#14407]

=20

In my test of adding documents,

1.    Size of the document is only 3KB.=20

2.    Schema validation is not enabled.=20

3.    I did not create any index yet.=20

4.    I did try to adjust cache size. I tried both default cache size
(256KB) and 50M and they performed equally.

5.    My test program is single-threaded. The program reads a template =
from
container A, generates a new XML document according to the template, and
saves the new document to container B. I am quite sure reading from
container A and generating a new XML document did not slow down because =
the
program completes instantly when the adding part was commented.

6.    Transaction is enabled.

7.    DB_CONFIG is:=20

set_lk_max_lockers 10000

set_lk_max_objects 10000

set_lk_max_locks   10000

=20

BR

Younger Wang

=20

=20

  _____ =20

From: Younger Wang [mailto:[email protected]]=20
Sent: 2006=C4=EA4=D4=C214=C8=D5 14:06
To: [email protected]
Subject: [bdbxml] Adding XML documents slows down when the container
contains large number of documents[#14407]

=20

Hi,

=20

When the container is empty, adding 100 documents takes 32 seconds; When =
the
container contains 10,000 documents, adding 100 takes 492 seconds. That =
is
too slow. How can I solve the problem? Thanks!

=20

BR
Younger Wang

=20


------=_NextPart_000_002D_01C66227.E2751B90
Content-Type: text/html;
	charset="gb2312"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dgb2312">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
 namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" =
name=3D"PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--@font-face
	{&#20307;}

 /* Font Definitions */
 @font-face
	{font-family:=CB=CE=CC=E5;
	panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
	{font-family:"\@=CB=CE=CC=E5";
	panose-1:2 1 6 0 3 1 1 1 1 1;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	text-align:justify;
	text-justify:inter-ideograph;
	font-size:10.5pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:9.0pt;
	font-family:=CB=CE=CC=E5;}
span.EmailStyle18
	{mso-style-type:personal;
	font-family:Arial;
	color:windowtext;}
span.EmailStyle19
	{mso-style-type:personal;
	font-family:Arial;
	color:navy;}
span.EmailStyle20
	{mso-style-type:personal;
	font-family:Arial;
	color:navy;}
span.EmailStyle21
	{mso-style-type:personal-reply;
	font-family:Arial;
	color:navy;}
@page Section1
	{size:595.3pt 841.9pt;
	margin:72.0pt 90.0pt 72.0pt 90.0pt;
	layout-grid:15.6pt;}
div.Section1
	{page:Section1;}
 /* List Definitions */
 @list l0
	{mso-list-id:2136172853;
	mso-list-type:hybrid;
	mso-list-template-ids:-1758423136 -71257584 67698713 67698715 67698703 =
67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
	{mso-level-tab-stop:18.0pt;
	mso-level-number-position:left;
	margin-left:18.0pt;
	text-indent:-18.0pt;}
@list l0:level2
	{mso-level-number-format:alpha-lower;
	mso-level-text:"%2\)";
	mso-level-tab-stop:42.0pt;
	mso-level-number-position:left;
	margin-left:42.0pt;
	text-indent:-21.0pt;}
@list l0:level3
	{mso-level-tab-stop:108.0pt;
	mso-level-number-position:left;
	text-indent:-18.0pt;}
@list l0:level4
	{mso-level-tab-stop:144.0pt;
	mso-level-number-position:left;
	text-indent:-18.0pt;}
@list l0:level5
	{mso-level-tab-stop:180.0pt;
	mso-level-number-position:left;
	text-indent:-18.0pt;}
@list l0:level6
	{mso-level-tab-stop:216.0pt;
	mso-level-number-position:left;
	text-indent:-18.0pt;}
@list l0:level7
	{mso-level-tab-stop:252.0pt;
	mso-level-number-position:left;
	text-indent:-18.0pt;}
@list l0:level8
	{mso-level-tab-stop:288.0pt;
	mso-level-number-position:left;
	text-indent:-18.0pt;}
@list l0:level9
	{mso-level-tab-stop:324.0pt;
	mso-level-number-position:left;
	text-indent:-18.0pt;}
ol
	{margin-bottom:0cm;}
ul
	{margin-bottom:0cm;}
-->
</style>

</head>

<body lang=3DZH-CN link=3Dblue vlink=3Dpurple =
style=3D'text-justify-trim:punctuation'>

<div class=3DSection1 style=3D'layout-grid:15.6pt'>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3D"Courier =
New"><span lang=3DEN-US
style=3D'font-size:10.0pt;font-family:"Courier New";color:navy'>Stupid =
me!&nbsp;
I used XPath to specify the node. The right way is =A1=B0 addindex =
&quot;&quot; ModelID
edge-element-equality-string =A1=B1 <o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3D"Courier =
New"><span lang=3DEN-US
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3D"Courier =
New"><span lang=3DEN-US
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:navy'>BR<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3D"Courier =
New"><span lang=3DEN-US
style=3D'font-size:10.0pt;font-family:"Courier New";color:navy'>Younger =
Wang<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D1 color=3Dnavy face=3DArial><span =
lang=3DEN-US
style=3D'font-size:9.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p><=
/span></font></p>

<div>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D=CB=CE=CC=E5><span lang=3DEN-US =
style=3D'font-size:12.0pt;font-family:=CB=CE=CC=E5'>

<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>

</span></font></div>

<p class=3DMsoNormal align=3Dleft style=3D'text-align:left'><b><font =
size=3D2
face=3DTahoma><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:Tahoma;
font-weight:bold'>From:</span></font></b><font size=3D2 =
face=3DTahoma><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:Tahoma'> Younger Wang
[mailto:[email protected]] <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> =
2006</span></font><font
size=3D2 face=3D=CB=CE=CC=E5><span =
style=3D'font-size:10.0pt;font-family:=CB=CE=CC=E5'>=C4=EA</span></font><=
font
size=3D2 face=3DTahoma><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:Tahoma'>4</span></font><font
size=3D2 face=3D=CB=CE=CC=E5><span =
style=3D'font-size:10.0pt;font-family:=CB=CE=CC=E5'>=D4=C2</span></font><=
font
size=3D2 face=3DTahoma><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:Tahoma'>17</span></font><font
size=3D2 face=3D=CB=CE=CC=E5><span =
style=3D'font-size:10.0pt;font-family:=CB=CE=CC=E5'>=C8=D5</span></font><=
font
size=3D2 face=3DTahoma><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:Tahoma'>
12:59<br>
<b><span style=3D'font-weight:bold'>To:</span></b> <st1:PersonName =
w:st=3D"on">[email protected]</st1:PersonName><br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: [bdbxml] =
Adding XML
documents slows down when the container contains large number of
documents[#14407]</span></font><font size=3D3 face=3D=CB=CE=CC=E5><span =
lang=3DEN-US
style=3D'font-size:12.0pt;font-family:=CB=CE=CC=E5'><o:p></o:p></span></f=
ont></p>

</div>

<p class=3DMsoNormal align=3Dleft style=3D'text-align:left'><font =
size=3D2
face=3D"Times New Roman"><span lang=3DEN-US =
style=3D'font-size:10.5pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3D"Courier =
New"><span lang=3DEN-US
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:navy'>Hi,<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3D"Courier =
New"><span lang=3DEN-US
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3D"Courier =
New"><span lang=3DEN-US
style=3D'font-size:10.0pt;font-family:"Courier New";color:navy'>I think =
I have
found the cause. Before adding a new document, my program queries =
against the
database. Since I haven=A1=AFt created any index, the query takes a very =
long time
when the database becomes large. <o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3D"Courier =
New"><span lang=3DEN-US
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3D"Courier =
New"><span lang=3DEN-US
style=3D'font-size:10.0pt;font-family:"Courier New";color:navy'>Now I =
have another
question. In my XML documents, namespace is not declared. When I add an =
index,
which namespace shall I use? I added index like =A1=B0 =
</span></font><font size=3D1
color=3Dnavy face=3D"Courier New"><span lang=3DEN-US =
style=3D'font-size:8.0pt;
font-family:"Courier New";color:navy'>addindex &quot;&quot; =
CPEInfo/ModelID
edge-element-equality-string</span></font><font size=3D2 color=3Dnavy
face=3D"Courier New"><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:navy'> =A1=B0, but the query plan showed the index was invalid for =
=A1=B0
collection(&quot;cpeinfo.dbxml&quot;)/CPEInfo/ModelID =
=A1=B1<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3D"Courier =
New"><span lang=3DEN-US
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3D"Courier =
New"><span lang=3DEN-US
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:navy'>BR<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3D"Courier =
New"><span lang=3DEN-US
style=3D'font-size:10.0pt;font-family:"Courier New";color:navy'>Younger =
Wang<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D1 color=3Dnavy face=3DArial><span =
lang=3DEN-US
style=3D'font-size:9.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p><=
/span></font></p>

<p class=3DMsoNormal><font size=3D1 color=3Dnavy face=3DArial><span =
lang=3DEN-US
style=3D'font-size:9.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p><=
/span></font></p>

<div>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D=CB=CE=CC=E5><span lang=3DEN-US =
style=3D'font-size:12.0pt;font-family:=CB=CE=CC=E5'>

<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>

</span></font></div>

<p class=3DMsoNormal align=3Dleft style=3D'text-align:left'><b><font =
size=3D2
face=3DTahoma><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:Tahoma;
font-weight:bold'>From:</span></font></b><font size=3D2 =
face=3DTahoma><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:Tahoma'> Younger Wang
[mailto:[email protected]] <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> =
2006</span></font><font
size=3D2 face=3D=CB=CE=CC=E5><span =
style=3D'font-size:10.0pt;font-family:=CB=CE=CC=E5'>=C4=EA</span></font><=
font
size=3D2 face=3DTahoma><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:Tahoma'>4</span></font><font
size=3D2 face=3D=CB=CE=CC=E5><span =
style=3D'font-size:10.0pt;font-family:=CB=CE=CC=E5'>=D4=C2</span></font><=
font
size=3D2 face=3DTahoma><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:Tahoma'>17</span></font><font
size=3D2 face=3D=CB=CE=CC=E5><span =
style=3D'font-size:10.0pt;font-family:=CB=CE=CC=E5'>=C8=D5</span></font><=
font
size=3D2 face=3DTahoma><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:Tahoma'>
12:51<br>
<b><span style=3D'font-weight:bold'>To:</span></b> <st1:PersonName =
w:st=3D"on">[email protected]</st1:PersonName><br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: [bdbxml] =
Adding XML
documents slows down when the container contains large number of
documents[#14407]</span></font><font size=3D3 face=3D=CB=CE=CC=E5><span =
lang=3DEN-US
style=3D'font-size:12.0pt;font-family:=CB=CE=CC=E5'><o:p></o:p></span></f=
ont></p>

</div>

<p class=3DMsoNormal align=3Dleft style=3D'text-align:left'><font =
size=3D2
face=3D"Times New Roman"><span lang=3DEN-US =
style=3D'font-size:10.5pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
lang=3DEN-US
style=3D'font-size:10.0pt;font-family:"Courier New"'>In my test of =
adding
documents,<o:p></o:p></span></font></p>

<p class=3DMsoPlainText =
style=3D'margin-left:18.0pt;text-indent:-18.0pt;mso-list:
l0 level1 lfo2'><![if !supportLists]><font size=3D2 face=3D"Courier =
New"><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-list:Ignore'>1.<font size=3D1 face=3D"Times New =
Roman"><span
style=3D'font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp; =
</span></font></span></span></font><![endif]><font
size=3D2 face=3D"Courier New"><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:
"Courier New"'>Size of the document is only 3KB. =
<o:p></o:p></span></font></p>

<p class=3DMsoPlainText =
style=3D'margin-left:18.0pt;text-indent:-18.0pt;mso-list:
l0 level1 lfo2'><![if !supportLists]><font size=3D2 face=3D"Courier =
New"><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-list:Ignore'>2.<font size=3D1 face=3D"Times New =
Roman"><span
style=3D'font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp; =
</span></font></span></span></font><![endif]><font
size=3D2 face=3D"Courier New"><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:
"Courier New"'>Schema validation is not enabled. =
<o:p></o:p></span></font></p>

<p class=3DMsoPlainText =
style=3D'margin-left:18.0pt;text-indent:-18.0pt;mso-list:
l0 level1 lfo2'><![if !supportLists]><font size=3D2 face=3D"Courier =
New"><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-list:Ignore'>3.<font size=3D1 face=3D"Times New =
Roman"><span
style=3D'font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp; =
</span></font></span></span></font><![endif]><font
size=3D2 face=3D"Courier New"><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:
"Courier New"'>I did not create any index yet. =
<o:p></o:p></span></font></p>

<p class=3DMsoPlainText =
style=3D'margin-left:18.0pt;text-indent:-18.0pt;mso-list:
l0 level1 lfo2'><![if !supportLists]><font size=3D2 face=3D"Courier =
New"><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-list:Ignore'>4.<font size=3D1 face=3D"Times New =
Roman"><span
style=3D'font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp; =
</span></font></span></span></font><![endif]><font
size=3D2 face=3D"Courier New"><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:
"Courier New"'>I did try to adjust cache size. I tried both default =
cache size
(256KB) and 50M and they performed equally.<o:p></o:p></span></font></p>

<p class=3DMsoPlainText =
style=3D'margin-left:18.0pt;text-indent:-18.0pt;mso-list:
l0 level1 lfo2'><![if !supportLists]><font size=3D2 face=3D"Courier =
New"><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-list:Ignore'>5.<font size=3D1 face=3D"Times New =
Roman"><span
style=3D'font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp; =
</span></font></span></span></font><![endif]><font
size=3D2 face=3D"Courier New"><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:
"Courier New"'>My test program is single-threaded. The program reads a =
template
from container A, generates a new XML document according to the =
template, and
saves the new document to container B. I am quite sure reading from =
container A
and generating a new XML document did not slow down because the program
completes instantly when the adding part was =
commented.<o:p></o:p></span></font></p>

<p class=3DMsoPlainText =
style=3D'margin-left:18.0pt;text-indent:-18.0pt;mso-list:
l0 level1 lfo2'><![if !supportLists]><font size=3D2 face=3D"Courier =
New"><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-list:Ignore'>6.<font size=3D1 face=3D"Times New =
Roman"><span
style=3D'font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp; =
</span></font></span></span></font><![endif]><font
size=3D2 face=3D"Courier New"><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:
"Courier New"'>Transaction is enabled.<o:p></o:p></span></font></p>

<p class=3DMsoPlainText =
style=3D'margin-left:18.0pt;text-indent:-18.0pt;mso-list:
l0 level1 lfo2'><![if !supportLists]><font size=3D2 face=3D"Courier =
New"><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-list:Ignore'>7.<font size=3D1 face=3D"Times New =
Roman"><span
style=3D'font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp; =
</span></font></span></span></font><![endif]><font
size=3D2 face=3D"Courier New"><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:
"Courier New"'>DB_CONFIG is: <o:p></o:p></span></font></p>

<p class=3DMsoPlainText style=3D'margin-left:21.0pt'><font size=3D2 =
face=3D"Courier New"><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Courier =
New"'>set_lk_max_lockers
10000<o:p></o:p></span></font></p>

<p class=3DMsoPlainText style=3D'margin-left:21.0pt'><font size=3D2 =
face=3D"Courier New"><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Courier =
New"'>set_lk_max_objects
10000<o:p></o:p></span></font></p>

<p class=3DMsoPlainText style=3D'margin-left:21.0pt'><font size=3D2 =
face=3D"Courier New"><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Courier =
New"'>set_lk_max_locks&nbsp;&nbsp;
10000<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
lang=3DEN-US
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
lang=3DEN-US
style=3D'font-size:10.0pt;font-family:"Courier =
New"'>BR<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
lang=3DEN-US
style=3D'font-size:10.0pt;font-family:"Courier New"'>Younger =
Wang<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D1 color=3Dnavy face=3DArial><span =
lang=3DEN-US
style=3D'font-size:9.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p><=
/span></font></p>

<p class=3DMsoNormal><font size=3D1 color=3Dnavy face=3DArial><span =
lang=3DEN-US
style=3D'font-size:9.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p><=
/span></font></p>

<div>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span lang=3DEN-US style=3D'font-size:12.0pt'>

<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>

</span></font></div>

<p class=3DMsoNormal align=3Dleft style=3D'text-align:left'><b><font =
size=3D2
face=3DTahoma><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:Tahoma;
font-weight:bold'>From:</span></font></b><font size=3D2 =
face=3DTahoma><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:Tahoma'> Younger Wang
[mailto:[email protected]] <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> =
2006</span></font><font
size=3D2 face=3D=CB=CE=CC=E5><span =
style=3D'font-size:10.0pt;font-family:=CB=CE=CC=E5'>=C4=EA</span></font><=
font
size=3D2 face=3DTahoma><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:Tahoma'>4</span></font><font
size=3D2 face=3D=CB=CE=CC=E5><span =
style=3D'font-size:10.0pt;font-family:=CB=CE=CC=E5'>=D4=C2</span></font><=
font
size=3D2 face=3DTahoma><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:Tahoma'>14</span></font><font
size=3D2 face=3D=CB=CE=CC=E5><span =
style=3D'font-size:10.0pt;font-family:=CB=CE=CC=E5'>=C8=D5</span></font><=
font
size=3D2 face=3DTahoma><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:Tahoma'>
14:06<br>
<b><span style=3D'font-weight:bold'>To:</span></b> <st1:PersonName =
w:st=3D"on">[email protected]</st1:PersonName><br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> [bdbxml] Adding =
XML
documents slows down when the container contains large number of =
documents[#14407]</span></font><font
size=3D3><span lang=3DEN-US =
style=3D'font-size:12.0pt'><o:p></o:p></span></font></p>

</div>

<p class=3DMsoNormal align=3Dleft style=3D'text-align:left'><font =
size=3D2
face=3D"Times New Roman"><span lang=3DEN-US =
style=3D'font-size:10.5pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal style=3D'layout-grid-mode:char'><font size=3D2 =
face=3D"Courier New"><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Courier =
New"'>Hi,<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'layout-grid-mode:char'><font size=3D2 =
face=3D"Courier New"><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal style=3D'layout-grid-mode:char'><font size=3D1 =
face=3D"Courier New"><span
lang=3DEN-US style=3D'font-size:9.0pt;font-family:"Courier New"'>When =
the container
is empty, adding 100 documents takes 32 seconds; When the container =
contains
10,000 documents, adding 100 takes 492 seconds. That is too slow. How =
can I
solve the problem? Thanks!<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'layout-grid-mode:char'><font size=3D1 =
face=3D"Courier New"><span
lang=3DEN-US style=3D'font-size:9.0pt;font-family:"Courier =
New"'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal style=3D'layout-grid-mode:char'><font size=3D1 =
face=3D"Courier New"><span
lang=3DEN-US style=3D'font-size:9.0pt;font-family:"Courier New"'>BR<br>
Younger Wang<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D1 face=3DArial><span lang=3DEN-US =
style=3D'font-size:
9.0pt;font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

</div>

</body>

</html>

------=_NextPart_000_002D_01C66227.E2751B90--