I see this is a very old post, but it cann't work when I get it from the github. Is this the version problem?
On Saturday, February 8, 2014 5:50:05 AM UTC+8, Andrey Yesyev wrote: > > *NOTE: The original project I got from > here > https://groups.google.com/forum/#!topicsearchin/orient-database/perfomance%7Csort:date%7Cspell:true/orient-database/VF_j5rGeffA > > <https://groups.google.com/forum/#!topicsearchin/orient-database/perfomance%7Csort:date%7Cspell:true/orient-database/VF_j5rGeffA> > > . Thanks to Milen Dyankov for it! I just modified it to multithread mode > and new OrientDB API* > > Ok, finally I've got some performance results for OrientDB. > Here is my environment: > > RAM 16Gb > CPU i7-3740QM 2.7Ghz > HDD 7200rpm > > Windows 7 Prof 64bit > OrientDB v1.7rc2 SNAPSHOT > DB type plocal > Connection mode - remote > Single mode (Not distributed, just one node, started by server.bat) > Default configuration > > In this test I was trying to figure out if I can get higher insertion rate > in multithread mode > > 1 thread > > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | Test inserting VERTICES_ONLY threads 1 > | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | test | documents | > vertices | edges | time (ms) | avg (doc/sec) | > | ---------------------------------------- | --------------- | > --------------- | --------------- | -------------------- | --------------- | > | 50000 documents with 2 fields each | 50000 | > 50000 | 0 | 3562 | 14037.06 | > | 50000 documents with 5 fields each | 50000 | > 50000 | 0 | 2881 | 17355.09 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 100000 documents with 2 fields each | 100000 | > 100000 | 0 | 4056 | 24654.83 | > | 100000 documents with 5 fields each | 100000 | > 100000 | 0 | 5576 | 17934.00 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 1000000 documents with 2 fields each | 1000000 | > 1000000 | 0 | 50031 | 19987.61 | > | 1000000 documents with 5 fields each | 1000000 | > 1000000 | 0 | 66602 | 15014.56 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | Test inserting VERTICES_AND_EDGES threads 1 > | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | test | documents | > vertices | edges | time (ms) | avg (doc/sec) | > | ---------------------------------------- | --------------- | > --------------- | --------------- | -------------------- | --------------- | > | 50000 documents with 2 fields each | 50000 | > 25000 | 25000 | 12711 | 3933.60 | > | 50000 documents with 5 fields each | 50000 | > 25000 | 25000 | 14535 | 3439.97 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 100000 documents with 2 fields each | 100000 | > 50000 | 50000 | 86934 | 1150.30 | > | 100000 documents with 5 fields each | 100000 | > 50000 | 50000 | 92906 | 1076.36 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 1000000 documents with 2 fields each | 623000 | > 500000 | 123000 |(timeout) 600928 | 1036.73 | > | 1000000 documents with 5 fields each | 620900 | > 500000 | 120900 |(timeout) 600668 | 1033.68 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | Test inserting EDGES_ONLY threads 1 > | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | test | documents | > vertices | edges | time (ms) | avg (doc/sec) | > | ---------------------------------------- | --------------- | > --------------- | --------------- | -------------------- | --------------- | > | 50000 documents with 2 fields each | 50000 | > 2 | 49998 | 71424 | 700.04 | > | 50000 documents with 5 fields each | 50000 | > 2 | 49998 | 82808 | 603.81 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 100000 documents with 2 fields each | 100000 | > 2 | 99998 | 397524 | 251.56 | > | 100000 documents with 5 fields each | 100000 | > 2 | 99998 | 394251 | 253.65 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 1000000 documents with 2 fields each | 125500 | > 0 | 125500 |(timeout) 600655 | 208.94 | > | 1000000 documents with 5 fields each | 123500 | > 0 | 123500 |(timeout) 600398 | 205.70 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > > > 2 threads > > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | Test inserting VERTICES_ONLY threads 2 > | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | test | documents | > vertices | edges | time (ms) | avg (doc/sec) | > | ---------------------------------------- | --------------- | > --------------- | --------------- | -------------------- | --------------- | > | 50000 documents with 2 fields each | 50000 | > 50000 | 0 | 3246 | 15403.57 | > | 50000 documents with 5 fields each | 50000 | > 50000 | 0 | 2279 | 21939.45 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 100000 documents with 2 fields each | 100000 | > 100000 | 0 | 3465 | 28860.03 | > | 100000 documents with 5 fields each | 100000 | > 100000 | 0 | 4444 | 22502.25 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 1000000 documents with 2 fields each | 1000000 | > 1000000 | 0 | 44121 | 22664.94 | > | 1000000 documents with 5 fields each | 1000000 | > 1000000 | 0 | 62515 | 15996.16 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | Test inserting VERTICES_AND_EDGES threads 2 > | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | test | documents | > vertices | edges | time (ms) | avg (doc/sec) | > | ---------------------------------------- | --------------- | > --------------- | --------------- | -------------------- | --------------- | > | 50000 documents with 2 fields each | 50000 | > 25000 | 25000 | 6216 | 8043.76 | > | 50000 documents with 5 fields each | 50000 | > 25000 | 25000 | 5698 | 8775.01 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 100000 documents with 2 fields each | 100000 | > 50000 | 50000 | 21480 | 4655.49 | > | 100000 documents with 5 fields each | 100000 | > 50000 | 50000 | 25726 | 3887.12 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 1000000 documents with 2 fields each | 480700 | > 250000 | 230700 |(timeout) 600890 | 799.98 | > | 1000000 documents with 5 fields each | 472000 | > 250000 | 222000 |(timeout) 601410 | 784.82 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | Test inserting EDGES_ONLY threads 2 > | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | test | documents | > vertices | edges | time (ms) | avg (doc/sec) | > | ---------------------------------------- | --------------- | > --------------- | --------------- | -------------------- | --------------- | > | 50000 documents with 2 fields each | 50002 | > 4 | 49998 | 19705 | 2537.53 | > | 50000 documents with 5 fields each | 50002 | > 4 | 49998 | 23434 | 2133.74 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 100000 documents with 2 fields each | 100002 | > 4 | 99998 | 105019 | 952.23 | > | 100000 documents with 5 fields each | 100002 | > 4 | 99998 | 109623 | 912.24 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 1000000 documents with 2 fields each | 211300 | > 0 | 211300 |(timeout) 600411 | 351.93 | > | 1000000 documents with 5 fields each | 216900 | > 0 | 216900 |(timeout) 600936 | 360.94 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > > |-----------------------------------------------------------------------------------------------------------------------------------------| > > 4 threads > > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | Test inserting VERTICES_ONLY threads 4 > | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | test | documents | > vertices | edges | time (ms) | avg (doc/sec) | > | ---------------------------------------- | --------------- | > --------------- | --------------- | -------------------- | --------------- | > | 50000 documents with 2 fields each | 50000 | > 50000 | 0 | 2413 | 20721.09 | > | 50000 documents with 5 fields each | 50000 | > 50000 | 0 | 2171 | 23030.86 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 100000 documents with 2 fields each | 100000 | > 100000 | 0 | 3600 | 27777.78 | > | 100000 documents with 5 fields each | 100000 | > 100000 | 0 | 4124 | 24248.30 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 1000000 documents with 2 fields each | 1000000 | > 1000000 | 0 | 37901 | 26384.53 | > | 1000000 documents with 5 fields each | 1000000 | > 1000000 | 0 | 47457 | 21071.71 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | Test inserting VERTICES_AND_EDGES threads 4 > | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | test | documents | > vertices | edges | time (ms) | avg (doc/sec) | > | ---------------------------------------- | --------------- | > --------------- | --------------- | -------------------- | --------------- | > | 50000 documents with 2 fields each | 50000 | > 25000 | 25000 | 3483 | 14355.44 | > | 50000 documents with 5 fields each | 50000 | > 25000 | 25000 | 3623 | 13800.72 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 100000 documents with 2 fields each | 100000 | > 50000 | 50000 | 9192 | 10879.03 | > | 100000 documents with 5 fields each | 100000 | > 50000 | 50000 | 10067 | 9933.45 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 1000000 documents with 2 fields each | 525500 | > 125000 | 400500 |(timeout) 601017 | 874.35 | > | 1000000 documents with 5 fields each | 522800 | > 125000 | 397800 |(timeout) 601126 | 869.70 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | Test inserting EDGES_ONLY threads 4 > | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | test | documents | > vertices | edges | time (ms) | avg (doc/sec) | > | ---------------------------------------- | --------------- | > --------------- | --------------- | -------------------- | --------------- | > | 50000 documents with 2 fields each | 50004 | > 8 | 49996 | 7673 | 6516.88 | > | 50000 documents with 5 fields each | 50004 | > 8 | 49996 | 8358 | 5982.77 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 100000 documents with 2 fields each | 100004 | > 8 | 99996 | 30451 | 3284.10 | > | 100000 documents with 5 fields each | 100004 | > 8 | 99996 | 33923 | 2947.97 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > | 1000000 documents with 2 fields each | 395300 | > 0 | 395300 |(timeout) 600839 | 657.91 | > | 1000000 documents with 5 fields each | 391500 | > 0 | 391500 |(timeout) 600702 | 651.74 | > > |-----------------------------------------------------------------------------------------------------------------------------------------| > > |-----------------------------------------------------------------------------------------------------------------------------------------| > > Some explanations to these results > Each test has 3 modes > VERTICES_ONLY - only ve > ... -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
