[#QB-3206] Improvement quick search speed if there are many builds

QuickBuild

Improvement quick search speed if there are many builds

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

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 ]