| << 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? |