DB

SQL

• stats (standard smoke report)
• results (standard smoke report)
• what is failing for selected revision (with some grouping by clients and conf data)
• what new is failing for this revision

ToDo

• rights/roles (to edit data, ... )

Num of rows in tables (estimate)

Now (post 0.5.2, 24.1.2008) there is about:

• 14.000 test cases
• 664 files in 46 directories
• 3MB of source code

There is also 21 (11 for 0.5.2, 10 for 0.5.1) active smokers.

ttest - saving all results

Actual state and history for 1000 revs:

• 14.000 x 20 x 1000 = 280 mil

Future state:

• test cases: 100.000
• active smokers: 200
• history for: 1000 revs

100.000 x 200 x 1000 = 20.000 mil

ttest - saving part of results

Run all test cases, but save only part of results to ttest table. Computed for future state (active smokers: 200, history for: 1000 revs).

• save all where tresult_id != 6 (not save 'ok' tests, but save 'failed', 'todo', ...)
  • each run has about 1000 failed, todo and skipped test cases: 1000 x 200 x 1000 = 200 mil
• save all where tresult_id <= 1 (save only 'failed' and 'not seen')
  • each run has about 50 failed test cases: 50 x 200 x 1000 = 10 mil
  • we couldn't distinguish not saved results (e.g. 'skipped' from 'ok')

Num of rows in tables (real data, db schema v0.04)

DB table list after ~26 782 test runs.

18 March 2010

• ttest - saving part of results (see prev chapter)
• 1-8 clients, history for 26 782 test runs
• DB size ~49 593 653 rows, 4.0 GiB
  • trun ~26 782 rows, 3.4 MiB
  • tfile ~8 988 350 rows, 667 MiB
  • ttest ~24 902 397 rows, 1,9 GiB

10 February 2009

• ttest - saving part of results (see prev chapter)
• 1-2 clients, history for 10253 test runs
• DB size ~14 284 373 rows, 1.1 GiB
  • trun ~10 253 rows, 1.9 MiB
  • tfile ~4 688 032 rows, 314 MiB
  • ttest ~9 455 049 rows, 762 MiB

26 December 2008

• ttest - saving part of results (see prev chapter)
• 1 client (2 sometimes), history for 6141 revs
• DB size ~8 688 691 rows, 692.4 MiB
  • trun 6 141 rows, 640 KiB
  • tfile ~2 980 203 rows, 208 MiB
  • ttest ~5 588 361 rows, 462 MiB

Num of rows in tables (real data, db schema v0.03)

• ttest - saving part of results (see prev chapter)
• 1 smoker, history for 1189 test runs
• DB size 158.9 MB
• tables:
  • trun 1,189 rows, 176.0 kB
  • tfile 672,478 rows, 52.6 MB
  • ttest 1,018,719 rows, 91.1 MB