Document View Performance Test and comparasion

Tags: not added yet

Document View Performance Test using 5000 Work Items

Tracker load time in seconds with 5000 work items using well structured tracker item tree:

Branch	Tree generation after- Settings A (First try / Average of 2nd and 3rd try)	Tree generation - Settings B (First try / Average of 2nd and 3rd try)	Total Page Loading time - Settings A (First try / Average of 2nd and 3rd try)	Total Page Loading time - Settings B (First try / Average of 2nd and 3rd try)	Modify a selected requirement
MySQL 5.5
7.8.0	16 / 8	20 / 8	38 / 28	50 / 28	15
7.9.0-RC	13 / 5	17 / 6	38 / 25	50 / 28	17
Oracle 12
7.8.0	113 / 105	160 / 128	146 / 131	201 / 151	18
7.9.0-RC	15 / 6	18 / 7	45 / 29	55 / 42	20

Where "First try" means: Oracle or MySQL query cache flush and a codeBeamer server restart with total work item cache flush.

Tracker load time in seconds with 10000 work items using well structured tracker item tree:

Branch	Tree generation after - Settings A (First try / Average of 2nd and 3rd try)	Tree generation - Settings B (First try / Average of 2nd and 3rd try)	Total Page Loading time - Settings A (First try / Average of 2nd and 3rd try)	Total Page Loading time - Settings B (First try / Average of 2nd and 3rd try)	Modify a selected requirement
MySQL 5.5
7.8.0	28 / 19	47 / 19	59 / 36	79 / 36	15
7.9.0-RC	25 / 10	24 / 10	50 / 33	55 / 35	20
Oracle 12
7.8.0	Not loading	Not loading	Not loading	Not loading	Not loading
7.9.0-RC	26 / 10	29 / 12	60 / 40	66 / 45	20

Where "First try" means: Oracle or MySQL query cache flush and a codeBeamer server restart with total work item cache flush.

	Performance Test - Average request time (20-30 ms difference between 2 tests can happen)
Overall performance before optimization	367
Overall performance after optimization	326

Settings A:

[!pasted-c173cba46976c985218766ae6b171b13.png!]

Settings B:

[!pasted-c2deedb3b3b16ca86e2388c48ff9a863.png!]