Guest User

SQLite vs SQLightning

a guest
Sep 14th, 2013
2,974
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