daily pastebin goal
85%
SHARE
TWEET

SQLite vs SQLightning

a guest Sep 14th, 2013 2,005 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Running on Ubuntu 12.04LTS with 3.10.11-031011-generic kernel. Crucial M4 512GB SSD with reiserfs.
  2.  
  3. Note that this version of SQLite now supports mmap'd I/O, but I haven't yet tweaked the benchmark code to use it. Will have to try that out soon too.
  4.  
  5. Vanilla SQLite3
  6. SQLite:     version 3.7.17
  7. Date:       Sat Sep 14 20:54:14 2013
  8. CPU:        4 * Intel(R) Core(TM)2 Extreme CPU Q9300  @ 2.53GHz
  9. CPUCache:   6144 KB
  10. Keys:       16 bytes each
  11. Values:     100 bytes each
  12. Entries:    1000000
  13. RawSize:    110.6 MB (estimated)
  14. ------------------------------------------------
  15. fillseqsync  :    8175.371 micros/op;    0.0 MB/s
  16. 168     /home/software/leveldb/test/dbbench_sqlite3-1.db
  17. 8761    /home/software/leveldb/test/dbbench_sqlite3-1.db-wal
  18. fillrandsync :    8308.706 micros/op;    0.0 MB/s
  19. 164     /home/software/leveldb/test/dbbench_sqlite3-2.db
  20. 8861    /home/software/leveldb/test/dbbench_sqlite3-2.db-wal
  21. fillseq      :      25.587 micros/op;    4.3 MB/s
  22. 153450  /home/software/leveldb/test/dbbench_sqlite3-3.db
  23. 16524   /home/software/leveldb/test/dbbench_sqlite3-3.db-wal
  24. fillseqbatch :       7.402 micros/op;   14.9 MB/s
  25. 153462  /home/software/leveldb/test/dbbench_sqlite3-4.db
  26. 16644   /home/software/leveldb/test/dbbench_sqlite3-4.db-wal
  27. fillrandom   :      33.235 micros/op;    3.3 MB/s
  28. 152561  /home/software/leveldb/test/dbbench_sqlite3-5.db
  29. 16524   /home/software/leveldb/test/dbbench_sqlite3-5.db-wal
  30. fillrandbatch :      18.847 micros/op;    5.9 MB/s
  31. 152625  /home/software/leveldb/test/dbbench_sqlite3-6.db
  32. 20692   /home/software/leveldb/test/dbbench_sqlite3-6.db-wal
  33. readrandom   :      22.645 micros/op;
  34. readseq      :       7.557 micros/op;   12.6 MB/s
  35. readreverse  :       7.456 micros/op;   12.8 MB/s
  36.  
  37.  
  38. SQLightning:
  39. SQLite:     version 3.7.17
  40. Date:       Sat Sep 14 20:49:14 2013
  41. CPU:        4 * Intel(R) Core(TM)2 Extreme CPU Q9300  @ 2.53GHz
  42. CPUCache:   6144 KB
  43. Keys:       16 bytes each
  44. Values:     100 bytes each
  45. Entries:    1000000
  46. RawSize:    110.6 MB (estimated)
  47. ------------------------------------------------
  48. fillseqsync  :    6171.233 micros/op;    0.0 MB/s
  49. 420     /home/software/leveldb/test/dbbench_sqlite3-1.db
  50. 0       /home/software/leveldb/test/dbbench_sqlite3-1.db-lock
  51. fillrandsync :    6231.249 micros/op;    0.0 MB/s
  52. 408     /home/software/leveldb/test/dbbench_sqlite3-2.db
  53. 0       /home/software/leveldb/test/dbbench_sqlite3-2.db-lock
  54. fillseq      :      31.778 micros/op;    3.5 MB/s
  55. 353077  /home/software/leveldb/test/dbbench_sqlite3-3.db
  56. 0       /home/software/leveldb/test/dbbench_sqlite3-3.db-lock
  57. fillseqbatch :       7.087 micros/op;   15.6 MB/s
  58. 353077  /home/software/leveldb/test/dbbench_sqlite3-4.db
  59. 0       /home/software/leveldb/test/dbbench_sqlite3-4.db-lock
  60. fillrandom   :      32.902 micros/op;    3.4 MB/s
  61. 334610  /home/software/leveldb/test/dbbench_sqlite3-5.db
  62. 4       /home/software/leveldb/test/dbbench_sqlite3-5.db-lock
  63. fillrandbatch :      13.754 micros/op;    8.0 MB/s
  64. 343303  /home/software/leveldb/test/dbbench_sqlite3-6.db
  65. 0       /home/software/leveldb/test/dbbench_sqlite3-6.db-lock
  66. readrandom   :       7.685 micros/op;
  67. readseq      :       1.551 micros/op;   61.5 MB/s
  68. readreverse  :       1.531 micros/op;   62.3 MB/s
  69.  
  70. http://symas.com/mdb
  71. https://gitorious.org/mdb/sqlightning
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top