<< Back to previous view |
[QB-3206] Improvement quick search speed if there are many builds
|
|
Status: | Resolved |
Project: | QuickBuild |
Component/s: | None |
Affects Version/s: | 8.0.7 |
Fix Version/s: | 8.0.8 |
Type: | Improvement | Priority: | Major |
Reporter: | Robin Shen | Assigned To: | Unassigned |
Resolution: | Fixed | Votes: | 0 |
Remaining Estimate: | Unknown | Time Spent: | Unknown |
Original Estimate: | Unknown |
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? |