50. Scenario 1 – compare with HBase hbasesequoiadbnoteData load21hrs,10mins,46sec20hrs,28mins,29sec4billions row, 30TBQuery on PK10521msUpdate on PK1613msDelete on PK619msinsert310539row/sBatch insert3113257row/sQuery on table scan152664183secUpdate on table scan3hrs,48mins,26sec1hrs,9mins,34s Delete on table scan3hrs,48mins,26sec1hrs,9mins,43s Query on 2nd index (hbase has to do table scan)3hrs,48mins,26sec21msDelete on 2nd index 3hrs,48mins,26sec19msUpdate on 2nd index 3hrs,48mins,26sec16msFile size36.4223.72TB50
51. Scenario 1 – compare with HBaseQuery on PK,msBatch insert, row/sinsert,row/sTable scan, secUpdate on PK, msQuery on 2nd index,ms51
52. Scenario 1 – compare with MongoDB mongodbsequoiadbnoteLoad data3h 58m 43s2h 57m 50s4 billion rows, 30TBQuery on index2320msUpdate on index3022msDelete on index2816msinsert29946419row/sBatch insert525714996row/sQuery on table scan37453536secUpdate on table scan36413536secDelete on table scan36413536sec insert(multiple thread)17094073row/s/threadBatch insert(multiple thread)23155027row/s/thread52
53. Scenario 1 – compare with MongoDBSingle thread batch insert,rows/secondMultiple threads batch insert,rows/second/threadMultiple thread insert,rows/second/threadQuery with index,msFull table scan,secondUpdate with index,ms53
54. Scenario 2 – single threadYCSB Test,8 Boxes,100 millions records,single thread insert/update/query3554