Guest User

Untitled

a guest
Jul 23rd, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.47 KB | None | 0 0
  1. Test parameters:
  2.  
  3. `--iterations=2 --concurrency=6 --iterations=1000`
  4.  
  5. ---
  6.  
  7. Using `view` **without** indexes:
  8. It took **over** 30 minutes to run the benchmark test.
  9. ```
  10. Benchmark
  11. Average number of seconds to run all queries: 1.748 seconds
  12. Minimum number of seconds to run all queries: 1.417 seconds
  13. Maximum number of seconds to run all queries: 2.009 seconds
  14. Number of clients running queries: 6
  15. Average number of queries per client: 10
  16.  
  17.  
  18. User time 0.63, System time 5.02
  19. Maximum resident set size 6236, Integral resident set size 0
  20. Non-physical pagefaults 10743, Physical pagefaults 0, Swaps 0
  21. Blocks in 0 out 0, Messages in 0 out 0, Signals 0
  22. Voluntary context switches 156957, Involuntary context switches 1860
  23. 00:55:03.455759338 - 01:24:11.694444807
  24. 00:31:08.238685469
  25. ```
  26.  
  27. Using a *dedicated* `table` with indexes:
  28. This benchmark test took *seconds* to complete.
  29. ```
  30. Benchmark
  31. Average number of seconds to run all queries: 0.010 seconds
  32. Minimum number of seconds to run all queries: 0.006 seconds
  33. Maximum number of seconds to run all queries: 0.096 seconds
  34. Number of clients running queries: 6
  35. Average number of queries per client: 10
  36.  
  37.  
  38. User time 0.75, System time 2.21
  39. Maximum resident set size 4196, Integral resident set size 0
  40. Non-physical pagefaults 10563, Physical pagefaults 0, Swaps 0
  41. Blocks in 0 out 0, Messages in 0 out 0, Signals 0
  42. Voluntary context switches 97014, Involuntary context switches 1578
  43. 00:51:53.653785574 - 00:52:04.829810291
  44. Test Duration: 00:00:11.176024717
  45. ```
Add Comment
Please, Sign In to add comment