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