Hi,
I am using OrientDB community version 2.1.9 on Ubuntu v14.0, the VPS is 8GB ram / SSD, and the startup settings are "-Xmx256m -storage.diskCache.bufferSize=2048", the current RAM usage is about 2713 MB.
I only have a single user online (me), and trying to import 200000 records into a Document database, each transaction inserts 2 records. It took about 20+ minutes to complete (about 166 transactions per second). Each record has less than 1KB user data => the insert speed should be about 332 KBps, however, it took about 5 MBps. Is it a normal behavior?
During insertion, the database engine was trying to write into files as following
/home/orientdb/orientdb-community-2.1.9/databases/test/Contact.ContentType.hib
/home/orientdb/orientdb-community-2.1.9/databases/test/contact.cpm
/home/orientdb/orientdb-community-2.1.9/databases/test/Contact.ContentType.hit
/home/orientdb/orientdb-community-2.1.9/databases/test/Contact.Status.hit
/home/orientdb/orientdb-community-2.1.9/databases/test/contactstatistics.cpm
/home/orientdb/orientdb-community-2.1.9/databases/test/IX_Contact_Status.sbt
/home/orientdb/orientdb-community-2.1.9/databases/test/contact.pcl
/home/orientdb/orientdb-community-2.1.9/databases/test/Contact.Status.hib
/home/orientdb/orientdb-community-2.1.9/databases/test/UQ_Contact_Email.hit
/home/orientdb/orientdb-community-2.1.9/databases/test/UQ_Contact_Email.him
/home/orientdb/orientdb-community-2.1.9/databases/test/contactstatistics.pcl
Here is the table structure
and indices on the class
Any idea will be appreciated!
My Best,
Hung Tran