Want more features on Pastebin? Sign Up, it's FREE!
Guest

SQLite vs SQLightning

By: a guest on Sep 14th, 2013  |  syntax: None  |  size: 3.17 KB  |  views: 507  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  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
clone this paste RAW Paste Data