Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Test parameters:
- `--iterations=2 --concurrency=6 --iterations=1000`
- ---
- Using `view` **without** indexes:
- It took **over** 30 minutes to run the benchmark test.
- ```
- Benchmark
- Average number of seconds to run all queries: 1.748 seconds
- Minimum number of seconds to run all queries: 1.417 seconds
- Maximum number of seconds to run all queries: 2.009 seconds
- Number of clients running queries: 6
- Average number of queries per client: 10
- User time 0.63, System time 5.02
- Maximum resident set size 6236, Integral resident set size 0
- Non-physical pagefaults 10743, Physical pagefaults 0, Swaps 0
- Blocks in 0 out 0, Messages in 0 out 0, Signals 0
- Voluntary context switches 156957, Involuntary context switches 1860
- 00:55:03.455759338 - 01:24:11.694444807
- 00:31:08.238685469
- ```
- Using a *dedicated* `table` with indexes:
- This benchmark test took *seconds* to complete.
- ```
- Benchmark
- Average number of seconds to run all queries: 0.010 seconds
- Minimum number of seconds to run all queries: 0.006 seconds
- Maximum number of seconds to run all queries: 0.096 seconds
- Number of clients running queries: 6
- Average number of queries per client: 10
- User time 0.75, System time 2.21
- Maximum resident set size 4196, Integral resident set size 0
- Non-physical pagefaults 10563, Physical pagefaults 0, Swaps 0
- Blocks in 0 out 0, Messages in 0 out 0, Signals 0
- Voluntary context switches 97014, Involuntary context switches 1578
- 00:51:53.653785574 - 00:52:04.829810291
- Test Duration: 00:00:11.176024717
- ```
Add Comment
Please, Sign In to add comment