Performance Tuning Document

Guide to improve performance of Document Database

<wiki:toc max_depth="4" />

This guide is specific for the Document Database. Please be sure to read the generic guide to the Performance-Tuning.

Massive Insertion

See Generic improvement on massive insertion.

Avoid document creation

You can avoid the creation of a new ODocument for each insertion by using the ODocument.reset() method that clears the instance making it ready for a new insert operation. Bear in mind that you will need to assign the document with the proper class after resetting as it is done in the code below.

NOTE: This trick works ONLY IN NON-TRANSACTIONAL contexts, because during transactions the documents could be kept in memory until commit.

Example:

    db.declareIntent( new OIntentMassiveInsert() );
    
    ODocument doc = new ODocument(db);
    for( int i = 0; i < 1000000; ++i ){
      doc.reset();
      doc.setClassname("Customer");
      doc.field("id", i);
      doc.field("name", "Jason");
      doc.save();
    }
    
    db.declareIntent( null );