Re: [bdbxml] query many number of document

## DOCUMENT - 1 #########
<drive name="c:">
<dir name="test" path="c:\test">
  <file name="file.txt" path="c:\test\file.txt"/> 
    <ver> 
      <number>2</number> 
      <size>100</size> 
      <date>100</size> 
      <fileid>100</size> 
      <blk> 
        <num>1</num> 
        <length>200</length> 
      </blk> 
    </ver> 
    <ver> 
      <number>1</number> 
      <size>100</size> 
      <date>100</size> 
      <fileid>100</size> 
      <blk> 
        <num>1</num> 
        <length>200</length> 
      </blk> 
    </ver> 
  </file>
</dir>
</drive>

## DOCUMENT - 2 ######### (Same Dir path but different file)
<drive name="c:">
<dir name="test" path="c:\test">
	<file name="file1.txt" path="c:\test\file1.txt"> 
	....ver ....
	</file>
</dir>
</drive>



I like to fetch all the file under dir path="C:\test"
dir path="C:\test" may contain 20,000 files under it.

I also need to do the following queries..

1. Fetch all the files under particular dir path.
2. Fetch all files irrespective of dir path.
3. What is the max ver number.

Do I need to add any Index ?
Do I need to change the document structure to fetch queries faster.

may be like this...and index on name, dirpath , fpath. will this help ???
<drive>
  <name>C:</name>
  <dir>
    <dirname>test</dirname>
    <dirpath>C:\test</dirpath>
    <file>
       <fname>file.txt</fname>
       <fpath>C:\test\file.txt</fpath>

--
View this message in context: http://www.nabble.com/query-many-number-of-document-t1469044.html#a3980141
Sent from the Berkeley DB Xml - General forum at Nabble.com.


------------------------------------------
To remove yourself from this list, send an
email to [email protected]