Hello dear BaseX Team,<div><br></div><div>I would like to load a big number of small documents in Basex.</div><div>What I do is to use a little Java program:</div><div><br></div><div><div>        Context ctx = new Context();</div>
<div>        new CreateDB(&quot;basex1&quot;).execute(ctx);</div><div>        new CreateIndex(&quot;fulltext&quot;).execute(ctx);</div><div>        System.err.println(&quot;\n* Show database information:&quot;);</div><div>
        System.err.print(new InfoDB().execute(ctx));</div><div>  </div><div>        for( ... ) {</div><div>            new Add(somedata, miname, collection).execute(ctx);</div><div>        }</div><div>  </div></div><div>I dont know if it is correct , efficient ?</div>
<div>Do you have a notion of transaction, like begin/commit ?</div><div>( I did not see something like that)</div><div><br></div><div>My concern is that it seems not to behave well when</div><div>the number of documents goes big:</div>
<div>(each doc is about 2500 bytes)</div><div><br></div><div>10000 =&gt; 54 seconds    ; 5.4 millis / document</div><div>20000 =&gt; 202 s             ; 10 ms</div><div>50000 =&gt; 862 s             ; 17.2 ms</div><div><br>
</div><div>And in fact I want to store more than 1 million!</div><div><br></div><div>Actually is there a limit in size ? Is 1 million x 2.5Kb OK?</div><div><br></div><div>Thank you very much</div><div>Tomaso</div><div><br>
</div><div><br></div><div><br></div>