summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorHarel Ben-Attia <harelba@gmail.com>2018-12-18 17:30:16 +0200
committerHarel Ben-Attia <harelba@gmail.com>2018-12-18 17:30:16 +0200
commit996070c061778782233d73c6891f56bfd68e14e2 (patch)
tree10129467aa8d2186005ff80c15d4b2e7bb5a052f
parent586874a67b8c945fc3d5b09d6c9b3754e51cbbc5 (diff)
wip
-rw-r--r--test/BENCHMARK.md21
-rwxr-xr-xtest/test-suite2
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))