Re: Organizing large collection

--===============1798899766415104285==
Content-Type: multipart/alternative; boundary="0000000000006e8dcf063579b6c5"

--0000000000006e8dcf063579b6c5
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Alberto,

collection("/db/records")/record will match all <record>...</record>
documents under /db/records and sub-folders (sub-collections?).

If you can organize them by date (year sub-folders), including that in the
collection parameter will mean less records to search. And all sub-folders
under that collection will still be included in the XPath search.



2025=E5=B9=B45=E6=9C=8819=E6=97=A5(=E6=9C=88) 17:23 Alberto Sim=C3=B5es <ha=
[email protected]>:

> Hello
>
> Are there differences in terms of performance between having a large
> collection (150k docs) with or without a folder structure?
>
> I want to treat them as a single collection, but I don't know if it helps
> to have sub-collections to organise them, or if that is irrelevant to eXi=
st.
>
> I appreciate any help you can provide.
> Alberto
>
> --
> Alberto Sim=C3=B5es
> _______________________________________________
> Exist-open mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/exist-open
>


--=20
Michael Westbay
Writer/System Administrator
http://www.japanesebaseball.com/

--0000000000006e8dcf063579b6c5
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi Alberto,</div><div><br></div><div><span style=3D"f=
ont-family:monospace;background-color:rgb(238,238,238)">collection(&quot;/d=
b/records&quot;)/record</span> will match all <span style=3D"font-family:mo=
nospace;background-color:rgb(238,238,238)">&lt;record&gt;...&lt;/record&gt;=
</span> documents under /db/records and sub-folders (sub-collections?).</di=
v><div><br></div><div>If you can organize them by date (year sub-folders), =
including that in the collection parameter will mean less records to search=
. And all sub-folders under that collection will still be included in the X=
Path search.</div><div><br></div><div><br></div></div><br><div class=3D"gma=
il_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">2025=
=E5=B9=B45=E6=9C=8819=E6=97=A5(=E6=9C=88) 17:23 Alberto Sim=C3=B5es &lt;<a =
href=3D"mailto:[email protected]">[email protected]</a>&gt;:<br></div><=
blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l=
eft:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>Hell=
o</div><div><br></div><div>Are there differences in terms of performance be=
tween having a large collection (150k docs) with or without a folder struct=
ure?</div><div><br></div><div>I want to treat them as a single collection, =
but I don&#39;t know if it helps to have sub-collections to organise them, =
or if that is irrelevant to eXist.</div><div><br></div><div>I appreciate an=
y help you can provide.</div><div>Alberto</div><br><span class=3D"gmail_sig=
nature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><di=
v dir=3D"ltr">Alberto Sim=C3=B5es<br></div></div></div>
_______________________________________________<br>
Exist-open mailing list<br>
<a href=3D"mailto:[email protected]" target=3D"_blank">Exist=
[email protected]</a><br>
<a href=3D"https://lists.sourceforge.net/lists/listinfo/exist-open" rel=3D"=
noreferrer" target=3D"_blank">https://lists.sourceforge.net/lists/listinfo/=
exist-open</a><br>
</blockquote></div><div><br clear=3D"all"></div><br><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature">Mi=
chael Westbay<br>Writer/System Administrator<br><a href=3D"http://www.japan=
esebaseball.com/" target=3D"_blank">http://www.japanesebaseball.com/</a></d=
iv>

--0000000000006e8dcf063579b6c5--


--===============1798899766415104285==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============1798899766415104285==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Exist-open mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/exist-open

--===============1798899766415104285==--