Test is done based on Nexus 5 device, Android 6.0.1
Process: I create 10,000 objects and keep them in memory. Then try to store them in the db (result shows in the following table). Then try to find all Booking objects that their id
contains a value (such as 1, 25, etc.). Finally try to delete all objects based on the best method each lib provides.
##Create
Inserting all 10000 objects into the Realm/Snappy DB.
Attempt | #1 | #2 | #3 | #4 | #5 | #6 | #7 | #8 | #9 | #10 |
---|---|---|---|---|---|---|---|---|---|---|
Realm (ms) | 1736 | 1611 | 1550 | 1556 | 1708 | 1923 | 1726 | 1843 | 1789 | 1744 |
SnappyDB (ms) | 1432 | 1447 | 1468 | 1437 | 1683 | 1893 | 1686 | 1774 | 1678 | 1689 |
##Read
Finding a list of items that its Booking.id contains a value (such as 1, 35, etc.)
Attempt | #1 | #2 | #3 | #4 | #5 | #6 | #7 | #8 | #9 | #10 |
---|---|---|---|---|---|---|---|---|---|---|
Realm (ms) | 24 | 10 | 3 | 3 | 5 | 6 | 9 | 9 | 6 | 6 |
SnappyDB (ms) | 187 | 74 | 7 | 4 | 93 | 111 | 8 | 2 | 108 | 87 |
##Delete
Delete all items with type Booking.class (all 10000 items in DB)
Attempt | #1 | #2 | #3 | #4 | #5 | #6 | #7 | #8 | #9 | #10 |
---|---|---|---|---|---|---|---|---|---|---|
Realm (ms) | 20 | 22 | 21 | 28 | 25 | 93 | 21 | 21 | 22 | 22 |
SnappyDB (ms) | 255 | 238 | 251 | 285 | 253 | 284 | 278 | 295 | 277 | 274 |