Key: |
QB-3206
|
Type: |
Improvement
|
Status: |
Resolved
|
Resolution: |
Fixed
|
Priority: |
Major
|
Assignee: |
Unassigned
|
Reporter: |
Robin Shen
|
Votes: |
0
|
Watchers: |
1
|
If you were logged in you would be able to see more operations.
|
|
|
QuickBuild
Created: 30/May/18 11:22 PM
Updated: 31/May/18 01:40 AM
|
|
Component/s: |
None
|
Affects Version/s: |
8.0.7
|
Fix Version/s: |
8.0.8
|
|
Original Estimate:
|
Unknown
|
Remaining Estimate:
|
Unknown
|
Time Spent:
|
Unknown
|
|
Finally, we found the main cause of late response time and it was on "quicksearch" feature.
Our QB_BUILD table has 1.6M build history around 10 thousands configurations.
So, users prefer to find a build with specific build version by quicksearch instead of going to specific configuration.
With mysql DB, it usually took less than 5 seconds to search among 1.6M builds.
However, sometimes, it took more than 50 seconds and made slow response time to other requests related with QB_BUILD table.
So, we blocked accessing quicksearch page temporary at this moment.
How about giving default beginDate on search page, like 10 days or 7 days, instead of opening to search among all build history?
Or, could you give me an advise to resolve this problem?
|
Description
|
Finally, we found the main cause of late response time and it was on "quicksearch" feature.
Our QB_BUILD table has 1.6M build history around 10 thousands configurations.
So, users prefer to find a build with specific build version by quicksearch instead of going to specific configuration.
With mysql DB, it usually took less than 5 seconds to search among 1.6M builds.
However, sometimes, it took more than 50 seconds and made slow response time to other requests related with QB_BUILD table.
So, we blocked accessing quicksearch page temporary at this moment.
How about giving default beginDate on search page, like 10 days or 7 days, instead of opening to search among all build history?
Or, could you give me an advise to resolve this problem? |
Show » |
There are no comments yet on this issue.
|
|