If you were logged in you would be able to see more operations.
|
|
|
QuickBuild
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
|
|
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.
|
Description
|
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.
|
Show » |
There are no entries against this issue.
|
|