Guest User

SQLite performance

a guest
Sep 20th, 2012
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.75 KB | None | 0 0
  1. ------------------------------------------------------------------
  2. SELECT_COUNT: 1,000,000
  3. THREAD_COUNT: 2
  4. Testing with one connections (ReadWrite) and filled table...
  5. Elapsed: 87,8 s
  6. Testing with one connections (ReadWrite) and filled table...
  7. Elapsed: 66,7 s
  8.  
  9.  
  10. ------------------------------------------------------------------
  11. SELECT_COUNT: 666,666
  12. THREAD_COUNT: 3
  13. Testing with one connections (ReadWrite) and filled table...
  14. Elapsed: 66,8 s
  15. Testing with one connections (ReadWrite) and filled table...
  16. Elapsed: 65,0 s
  17.  
  18.  
  19. ------------------------------------------------------------------
  20. SELECT_COUNT: 500,000
  21. THREAD_COUNT: 4
  22. Testing with one connections (ReadWrite) and filled table...
  23. Elapsed: 41,7 s
  24. Testing with one connections (ReadWrite) and filled table...
  25. Elapsed: 62,5 s
  26.  
  27.  
  28. ------------------------------------------------------------------
  29. SELECT_COUNT: 400,000
  30. THREAD_COUNT: 5
  31. Testing with one connections (ReadWrite) and filled table...
  32. Elapsed: 27,4 s
  33. Testing with one connections (ReadWrite) and filled table...
  34. Elapsed: 60,5 s
  35.  
  36.  
  37. ------------------------------------------------------------------
  38. SELECT_COUNT: 333,333
  39. THREAD_COUNT: 6
  40. Testing with one connections (ReadWrite) and filled table...
  41. Elapsed: 18,6 s
  42. Testing with one connections (ReadWrite) and filled table...
  43. Elapsed: 60,3 s
  44.  
  45.  
  46. ------------------------------------------------------------------
  47. SELECT_COUNT: 285,714
  48. THREAD_COUNT: 7
  49. Testing with one connections (ReadWrite) and filled table...
  50. Elapsed: 14,5 s
  51. Testing with one connections (ReadWrite) and filled table...
  52. Elapsed: 59,6 s
  53.  
  54.  
  55. ------------------------------------------------------------------
  56. SELECT_COUNT: 250,000
  57. THREAD_COUNT: 8
  58. Testing with one connections (ReadWrite) and filled table...
  59. Elapsed: 12,8 s
  60. Testing with one connections (ReadWrite) and filled table...
  61. Elapsed: 58,6 s
  62.  
  63.  
  64. ------------------------------------------------------------------
  65. SELECT_COUNT: 222,222
  66. THREAD_COUNT: 9
  67. Testing with one connections (ReadWrite) and filled table...
  68. Elapsed: 12,6 s
  69. Testing with one connections (ReadWrite) and filled table...
  70. Elapsed: 56,8 s
  71.  
  72.  
  73. ------------------------------------------------------------------
  74. SELECT_COUNT: 200,000
  75. THREAD_COUNT: 10
  76. Testing with one connections (ReadWrite) and filled table...
  77. Elapsed: 11,5 s
  78. Testing with one connections (ReadWrite) and filled table...
  79. Elapsed: 56,2 s
  80.  
  81.  
  82. ------------------------------------------------------------------
  83. SELECT_COUNT: 100,000
  84. THREAD_COUNT: 20
  85. Testing with one connections (ReadWrite) and filled table...
  86. Elapsed: 10,7 s
  87. Testing with one connections (ReadWrite) and filled table...
  88. Elapsed: 51,1 s
  89.  
  90.  
  91. ------------------------------------------------------------------
  92. SELECT_COUNT: 66,666
  93. THREAD_COUNT: 30
  94. Testing with one connections (ReadWrite) and filled table...
  95. Elapsed: 10,7 s
  96. Testing with one connections (ReadWrite) and filled table...
  97. Elapsed: 50,7 s
  98.  
  99.  
  100. ------------------------------------------------------------------
  101. SELECT_COUNT: 50,000
  102. THREAD_COUNT: 40
  103. Testing with one connections (ReadWrite) and filled table...
  104. Elapsed: 10,8 s
  105. Testing with one connections (ReadWrite) and filled table...
  106. Elapsed: 51,7 s
  107.  
  108.  
  109. ------------------------------------------------------------------
  110. SELECT_COUNT: 40,000
  111. THREAD_COUNT: 50
  112. Testing with one connections (ReadWrite) and filled table...
  113. Elapsed: 10,6 s
  114. Testing with one connections (ReadWrite) and filled table...
  115. Elapsed: 52,2 s
  116.  
  117.  
  118. ------------------------------------------------------------------
  119. SELECT_COUNT: 33,333
  120. THREAD_COUNT: 60
  121. Testing with one connections (ReadWrite) and filled table...
  122. Elapsed: 10,8 s
  123. Testing with one connections (ReadWrite) and filled table...
  124. Elapsed: 53,0 s
  125.  
  126.  
  127. ------------------------------------------------------------------
  128. SELECT_COUNT: 28,571
  129. THREAD_COUNT: 70
  130. Testing with one connections (ReadWrite) and filled table...
  131. Elapsed: 10,8 s
  132. Testing with one connections (ReadWrite) and filled table...
  133. Elapsed: 54,0 s
  134.  
  135.  
  136. ------------------------------------------------------------------
  137. SELECT_COUNT: 25,000
  138. THREAD_COUNT: 80
  139. Testing with one connections (ReadWrite) and filled table...
  140. Elapsed: 11,2 s
  141. Testing with one connections (ReadWrite) and filled table...
  142. Elapsed: 54,8 s
  143.  
  144.  
  145. ------------------------------------------------------------------
  146. SELECT_COUNT: 22,222
  147. THREAD_COUNT: 90
  148. Testing with one connections (ReadWrite) and filled table...
  149. Elapsed: 11,0 s
  150. Testing with one connections (ReadWrite) and filled table...
  151. Elapsed: 56,0 s
  152.  
  153.  
  154. ------------------------------------------------------------------
  155. SELECT_COUNT: 20,000
  156. THREAD_COUNT: 100
  157. Testing with one connections (ReadWrite) and filled table...
  158. Elapsed: 11,2 s
  159. Testing with one connections (ReadWrite) and filled table...
  160. Elapsed: 57,2 s
Advertisement
Add Comment
Please, Sign In to add comment