Hi Shivanandan, the easy way to go faster is using plocal instead of remote, but I don't know if in your case it's possible (other instances OrientDB have to be shut down for the time ETL works...)
Luigi 2015-02-19 7:19 GMT+01:00 Shivanandan Gupta <[email protected]>: > Hi All, > > I tried loading data from csb file to in-memory graphdatabase class and > the statistics I am getting is given below. I used json ETL file to load > data from csv. If I anyone has a better way to load the same amount of data > quickly them please suggest the way. > > We are planning of implementing a near to realtime DWH on orientdb. > > > *RecordsLoaded* > > *AttributesPerRecords* > > *DataVolume(csv file)* > > *TimeTaken (MS)* > > *TimeTaken(Minutes)* > > 1,000,320 > > 75 > > 250 MB > > 261365 > > 4.36 > > > > { > "source": { "file": { "path": "F:\Work\MDATA-ETL\s_asset.csv" } }, > "extractor": { "row": {} }, > "transformers": [ > { "csv": {} }, > { "vertex": { "class": "S_ASSET" } } > ], > "loader": { > "orientdb": { > "dbURL": "remote:localhost/databases/indb", > "dbUser": "root", > "dbPassword": "root", > "dbAutoCreate": true, > "tx": false, > "batchCommit": 10000, > "dbType": "graph" > } > } > } > > > Thanks in advance. > > Regards, > Shivanandan Gupta > > -- > > --- > 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. > -- --- 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.
