Hi Luigi, Thanks for your response ,I am loading the csv file from the same server where orientdb is installed, I tried doing a plocal (create a DB as plocal ? ) can you please help me how to go with it? I am a newbei to orientdb.
We are trying to have a data model as DWH like facts and dimensions in orientdb. Thanks, Shivanandan Gupta On Thursday, 19 February 2015 13:26:58 UTC+5:30, Luigi Dell'Aquila wrote: > > 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] > <javascript:>>: > >> 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] <javascript:>. >> 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.
