orientdborientjs

OrientDB select record count from all graph classes

Any way to get record count for each graph class (V, E and their subclasses)?

I tried to build query in SQL format for current case:

SELECT @class, count(*) FROM V GROUP BY @class
SELECT @class, count(*) FROM E GROUP BY @class

But using count() + GROUP BY is extrimply slow combination.

While console command list classes works fast and return values for count of records in each class (field RECORDS), how to extract this counts via SQL query (or via OrientJS API)?

Solution

  • The main idea is find a way to:

    1. Get list of all classes if database
    2. Get count of records that stored in each class

    Technical details

    In OrientDB functions you have access to orient variable that have .getDatabase() method. And this method return JAVA ODatabaseDocumentTx class instance. This class provides the method .countClass(className) that returns the number of the records of the class className (method documentation) and it works realy fast.

    Solution

    Create function in OrientDB Studio with name "getClassCounts", language "javascript", idempotent: true:

    var db = orient.getDatabase();
var classesRawInfo = db.getMetadata().getImmutableSchemaSnapshot().getClasses().toArray();
var classesList = {};
var i = classesRawInfo.length;

while(--i) {
    var className = classesRawInfo[i].name;
    classesList[className] = db.countClass(className);
}

return classesList;

    Executing: