Very large QC project lags or fails when retrieving data for a test set wtih many (10K) tests

  • Questions
  • Very large QC project lags or fails when retrieving data for a test set wtih many (10K) tests
Question ID: 106198
0
0

We have a very large project in QC 11.52 (with ORACLE), how to improve performance on the database or app side? Our new production environment seems to hang a bit on the GetRunValue when we click on a testset with large number of tests up to 9-10k or when we click on the test run module. Sometimes the ui does not even come back with results.

Marked as spam
Posted by (Questions: 185, Answers: 13)
Asked on July 22, 2015 3:19 pm
5 views
Answers (2)
0
Private answer

You could try to see if this is isolated to one project.
If it seems to be SERVER-wide (all projects), you may have too small of a JAVA-HEAP setting (see other posts about increasing that http://eyeontesting.com/questions/4367/alm-server-muted-java-heap-space.html, http://eyeontesting.com/questions/8730/java-heap-size-error.html)

If it is only one project and your HEAP looks to be ample, it might just be the indexing or something amiss in the project data.

MAKE A BACKUP of your project (project DB/Schema and Repository), then
Try a REPAIR on the project (rt-click on project in Site Admin, then Maintain/REPAIR) to see if that fixes any messed up indexes.

Marked as spam
Posted by (Questions: 3, Answers: 466)
Answered on July 22, 2015 3:28 pm
0
Private answer

It was only one project and we have already increased our HEAP.

Repair seems to be working and helped!

Marked as spam
Posted by (Questions: 185, Answers: 13)
Answered on July 22, 2015 3:30 pm