--------------------------------------------------------------------------------------------- SQL QUERY (CACHED, 1000 rows) --------------------------------------------------------------------------------------------- Document Path: /d7/node/1 Document Length: 85698 bytes Concurrency Level: 1 Time taken for tests: 5.728 seconds Complete requests: 100 Failed requests: 0 Write errors: 0 Total transferred: 8614100 bytes HTML transferred: 8569800 bytes Requests per second: 17.46 [#/sec] (mean) Time per request: 57.276 [ms] (mean) Time per request: 57.276 [ms] (mean, across all concurrent requests) Transfer rate: 1468.71 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.0 0 0 Processing: 48 57 4.4 57 70 Waiting: 48 57 4.4 57 70 Total: 48 57 4.4 57 70 Percentage of the requests served within a certain time (ms) 50% 57 66% 59 75% 59 80% 60 90% 64 95% 66 98% 69 99% 70 100% 70 (longest request) --------------------------------------------------------------------------------------------- SQL QUERY (CACHED, 20 rows) --------------------------------------------------------------------------------------------- Document Path: /d7/node/1 Document Length: 9909 bytes Concurrency Level: 1 Time taken for tests: 5.533 seconds Complete requests: 100 Failed requests: 0 Write errors: 0 Total transferred: 1035200 bytes HTML transferred: 990900 bytes Requests per second: 18.07 [#/sec] (mean) Time per request: 55.332 [ms] (mean) Time per request: 55.332 [ms] (mean, across all concurrent requests) Transfer rate: 182.70 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.0 0 0 Processing: 46 55 5.0 55 74 Waiting: 46 55 5.0 55 74 Total: 46 55 5.0 55 74 Percentage of the requests served within a certain time (ms) 50% 55 66% 57 75% 58 80% 59 90% 62 95% 64 98% 66 99% 74 100% 74 (longest request) --------------------------------------------------------------------------------------------- VIEWS QUERY (CACHED, 1000 rows) --------------------------------------------------------------------------------------------- Document Path: /d7/node/1 Document Length: 358177 bytes Concurrency Level: 1 Time taken for tests: 11.472 seconds Complete requests: 100 Failed requests: 0 Write errors: 0 Total transferred: 35862000 bytes HTML transferred: 35817700 bytes Requests per second: 8.72 [#/sec] (mean) Time per request: 114.723 [ms] (mean) Time per request: 114.723 [ms] (mean, across all concurrent requests) Transfer rate: 3052.69 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.0 0 0 Processing: 98 115 6.5 115 136 Waiting: 85 99 5.7 99 118 Total: 98 115 6.5 115 136 Percentage of the requests served within a certain time (ms) 50% 115 66% 117 75% 118 80% 120 90% 122 95% 125 98% 131 99% 136 100% 136 (longest request) --------------------------------------------------------------------------------------------- VIEWS QUERY (CACHED, 20 rows) --------------------------------------------------------------------------------------------- Document Path: /d7/node/1 Document Length: 15828 bytes Concurrency Level: 1 Time taken for tests: 9.414 seconds Complete requests: 100 Failed requests: 0 Write errors: 0 Total transferred: 1627100 bytes HTML transferred: 1582800 bytes Requests per second: 10.62 [#/sec] (mean) Time per request: 94.136 [ms] (mean) Time per request: 94.136 [ms] (mean, across all concurrent requests) Transfer rate: 168.79 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.0 0 0 Processing: 82 94 8.0 92 126 Waiting: 82 94 8.0 92 126 Total: 82 94 8.0 92 126 Percentage of the requests served within a certain time (ms) 50% 92 66% 95 75% 96 80% 97 90% 104 95% 111 98% 123 99% 126 100% 126 (longest request) --------------------------------------------------------------------------------------------- SQL QUERY (NO CACHES, 1000 rows) --------------------------------------------------------------------------------------------- Document Path: /d7/node/1 Document Length: 85820 bytes Concurrency Level: 1 Time taken for tests: 8.498 seconds Complete requests: 100 Failed requests: 0 Write errors: 0 Total transferred: 8626300 bytes HTML transferred: 8582000 bytes Requests per second: 11.77 [#/sec] (mean) Time per request: 84.978 [ms] (mean) Time per request: 84.978 [ms] (mean, across all concurrent requests) Transfer rate: 991.33 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.0 0 0 Processing: 72 85 5.9 84 104 Waiting: 72 85 5.9 84 104 Total: 72 85 5.9 85 104 Percentage of the requests served within a certain time (ms) 50% 85 66% 87 75% 88 80% 89 90% 94 95% 97 98% 98 99% 104 100% 104 (longest request) --------------------------------------------------------------------------------------------- SQL QUERY (NO CACHES, 20 rows) --------------------------------------------------------------------------------------------- Document Path: /d7/node/1 Document Length: 10031 bytes Concurrency Level: 1 Time taken for tests: 5.948 seconds Complete requests: 100 Failed requests: 0 Write errors: 0 Total transferred: 1047400 bytes HTML transferred: 1003100 bytes Requests per second: 16.81 [#/sec] (mean) Time per request: 59.483 [ms] (mean) Time per request: 59.483 [ms] (mean, across all concurrent requests) Transfer rate: 171.96 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.0 0 0 Processing: 47 59 12.3 57 166 Waiting: 47 59 12.3 57 166 Total: 47 59 12.3 58 166 Percentage of the requests served within a certain time (ms) 50% 58 66% 59 75% 61 80% 62 90% 64 95% 72 98% 85 99% 166 100% 166 (longest request)