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?