History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: QB-3206
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Unassigned
Reporter: Robin Shen
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
QuickBuild

Improvement quick search speed if there are many builds

Created: 30/May/18 11:22 PM   Updated: 31/May/18 01:40 AM
Return to search
Component/s: None
Affects Version/s: 8.0.7
Fix Version/s: 8.0.8

Original Estimate: Unknown Remaining Estimate: Unknown Time Spent: Unknown


 Description  « Hide
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?

 All   Comments   Work Log   Change History      Sort Order:
Change by Robin Shen [30/May/18 11:27 PM]
Field Original Value New Value
Comment [ http://track.pmease.com/browse/QB-3206 ]

Change by Robin Shen [30/May/18 11:27 PM]
Comment [ I guess users are specifying wildcard search for versions and it can be very slow. Nevertheless, I filed below improvement request to limit build search on a specific date range. ]

Change by Steve Luo [31/May/18 01:40 AM]
Status Open [ 1 ] Resolved [ 5 ]
Assignee Robin Shen [ robinshine ]
Resolution Fixed [ 1 ]

Change by Steve Luo [31/May/18 01:40 AM]
Fix Version/s 8.0.8 [ 11802 ]