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

Key: QB-1357
Type: Improvement Improvement
Status: Open Open
Priority: Major Major
Assignee: Robin Shen
Reporter: Siim Käba
Votes: 0
Watchers: 0
Operations

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

Startup query performance

Created: 30/Aug/12 02:05 PM   Updated: 30/Aug/12 02:05 PM
Component/s: None
Affects Version/s: 4.0.45
Fix Version/s: None

Original Estimate: Unknown Remaining Estimate: Unknown Time Spent: Unknown
Environment: mysql


 Description  « Hide
Although most QB queries are super fast due to simple queries and indexes theres one db query that's extremely slow compared to others:
MonProxy-SQL-PreparedStatement: /* from Build where status = :status */ select build0_.QB_ID as QB1_?_, build0_.QB_BEGIN_DATE as QB2_?_, build0_.QB_CANCELLER_ID as QB13_?_, build0_.QB_CONFIGURATION_ID as QB14_?_, build0_.QB_DESCRIPTION as QB3_?_, build0_.QB_DURATION as QB4_?_, build0_.QB_ERROR_MESSAGE as QB5_?_, build0_.QB_PROMOTED_FROM_ID as QB15_?_, build0_.QB_REPOSITORY_RUNTIMES as QB6_?_, build0_.QB_REQUESTER_ID as QB16_?_, build0_.QB_SCHEDULED as QB7_?_, build0_.QB_STATUS as QB8_?_, build0_.QB_STATUS_DATE as QB9_?_, build0_.QB_STEP_RUNTIMES as QB10_?_, build0_.QB_VARIABLE_VALUES as QB11_?_, build0_.QB_VERSION as QB12_?_ from QB_BUILD build0_ where build0_.QB_STATUS=?

113086 ms last time. It seems that it's required just once during startup and isn't therefore so important but in higher load systems downtime is quite important.


 All   Comments   Work Log   Change History      Sort Order:
There are no comments yet on this issue.