diff options
author | Harel Ben-Attia <harelba@gmail.com> | 2018-12-18 17:30:16 +0200 |
---|---|---|
committer | Harel Ben-Attia <harelba@gmail.com> | 2018-12-18 17:30:16 +0200 |
commit | 996070c061778782233d73c6891f56bfd68e14e2 (patch) | |
tree | 10129467aa8d2186005ff80c15d4b2e7bb5a052f | |
parent | 586874a67b8c945fc3d5b09d6c9b3754e51cbbc5 (diff) |
wip
-rw-r--r-- | test/BENCHMARK.md | 21 | ||||
-rwxr-xr-x | test/test-suite | 2 |
2 files changed, 22 insertions, 1 deletions
diff --git a/test/BENCHMARK.md b/test/BENCHMARK.md index 464c5de..8a7f0a4 100644 --- a/test/BENCHMARK.md +++ b/test/BENCHMARK.md @@ -23,6 +23,27 @@ The benchmark executes simple `select count(*) from <file>` queries for each com ## Hardware OSX Sierra on a 15" Macbook Pro from Mid 2015, with 16GB of RAM, and an internal Flash Drive of 256GB. + +## Running the benchmark + +* Create and activate a python 2.7 virtual environment called `py2-q`, and `pip install -r requirements.txt` +* $ `./test-all BenchmarkTests.test_q_matrix` +* Create and avtivate a python 3.x virtual environment called `py3-q`, and `pip install -r requirements.txt` +* $ `./test-all BenchmarkTests.test_q_matrix` +* Ensure that textql is installed +* $ `./test-all BenchmarkTests.test_textql` + +The results from each of the benchmarks will be written to `<virtual-env-name>.benchmark-results`, and `textql.benchmark-results` for the textql test. + +* $ `paste py2-q.benchmark-results py3-q.benchmark-results textql.benchmark-results > all.benchmark-results` + +## Updating the benchmark markdown document file +The results should reside in the following [google sheet](https://docs.google.com/spreadsheets/d/1Ljr8YIJwUQ5F4wr6ATga5Aajpu1CvQp1pe52KGrLkbY/edit?usp=sharing). + +* Paste `all.benchmark-results` to the google sheet, near "Fil raw results here". + +* All the graphs below will be updated automatically. + ## Results ### 1 Column Table diff --git a/test/test-suite b/test/test-suite index f0dc925..bd589bd 100755 --- a/test/test-suite +++ b/test/test-suite @@ -2416,7 +2416,7 @@ class BenchmarkTests(AbstractQTestCase): for columns in [1, 5, 10, 20, 50, 100]: for lines in [1, 10, 100, 1000, 10000, 100000, 1000000]: attempt_results = [] - for attempt in range(3): + for attempt in range(10): filename = self._prepare_test_file(lines, columns) if DEBUG: print("Testing {}".format(filename)) |