LibraryOfCongress / concordia

70%

main: 70%

LAST BUILD ON BRANCH optimize-sitereport-queries

branch: optimize-sitereport-queries

CHANGE BRANCH

x

Reset

• optimize-sitereport-queries
• 1073-restore-background-color-when-fullscreen
• 1105-update-registration-form-submission
• 368-update-help-popover-text
• VVH-gettysburg
• VVH-patch-1
• VVH-patch-7
• VVH-review-update
• VVH-transcribathon
• activation-bugfixes
• activation-email
• activity-ui-2
• activity-ui-asset-list-info-tooltip-overhaul
• activity-ui-avoid-openseadragon-reloads
• activity-ui-disable-reference-strip
• activity-ui-display-campaign-thumbnails
• activity-ui-fix-saved-page-restoration
• activity-ui-improved-contention-display
• activity-ui-info-panel-cleanup
• activity-ui-invalid-mode-fallback
• activity-ui-less-scrolling
• activity-ui-more-info-display-improvements
• activity-ui-ms-edge-polyfills
• activity-ui-overhaul-image-viewer-controls
• activity-ui-packaging
• activity-ui-preserve-unsaved-text-for-new-transcriptions
• activity-ui-prototype
• activity-ui-remove-numeric-difficulty-display
• activity-ui-reservation-in-progress
• activity-ui-reset-hidden-thumbnails
• activity-ui-restore-nothing-to-transcribe-help-popover
• activity-ui-retain-all-touched-assets
• activity-ui-retry-fetch-errors
• activity-ui-review-badges-empty-transcriptions
• activity-ui-sort-options
• activity-ui-stable-sorting
• activity-ui-state-management
• activity-ui-style-touch-up
• activity-ui-suppress-reservation-warning-banners
• activity-ui-tab-mutex
• activity-ui-text-modification-tracking
• activity-ui-transcription-display-improvements
• activity-ui-transient-error-display
• add-accessibility-docs
• add-admin-filtering-permissions
• add-base-template-blocks
• add-cfn-lint-to-tools
• add-extra-migrations
• add-help-popovers
• add-more-pre-commit-hooks
• add-package-checks-to-ci
• add-pagination-link-headers
• add-review-option-to-transcription-submission-dialog
• additional-pre-commit-hooks
• admin-enhancements
• admin-filters
• admin-navigation-links
• admin-reopen-feature
• admin-site-report-filtered-exports
• admin-warning-banner
• allow-clean-version-releases
• allow-unicode-slugs
• already-activated-message
• anon-browser-session
• anonymize-accounts
• aria-updates
• asset-link-bugfix
• automate-data-load
• bag-info-typo
• bagit-export-updates
• bastion-hosts-git
• bastion-postgresql-update
• better-docker-development-experience
• bourne-carousel-slide
• branching-process
• browse-tags
• bump-dependencies
• campaign-ui-updates
• campaigns-topics-dropdown
• cantaloupe
• carousel-add-review
• carousel-cms
• carousel-suffrage
• celery-conn-max-age
• celery-redis
• celery-regression
• cfn-ecs-executionrole-tidying
• change-profile-activity-sort-field
• change-sentry-dsns
• channels-prototype
• check-source-not-tilesource
• cleanup-logging-config
• cloudformation-cleanup
• cloudwatch-login-events
• colefemeno-design-principles
• colefemeno-latest-gettysburg
• completed-item-export
• conn-max-age-aws
• container-build-script
• coveralls
• debug-logging
• delete-indices-bugfix
• dependabot/pip/boto3-1.9.159
• dependabot/pip/botocore-1.12.156
• dependabot/pip/botocore-1.12.157
• dependabot/pip/botocore-1.12.158
• dependabot/pip/botocore-1.12.159
• dependabot/pip/botocore-1.12.160
• dependabot/pip/botocore-1.12.161
• dependabot/pip/cfn-lint-0.21.3
• dependabot/pip/cfn-lint-0.21.4
• dependabot/pip/django-2.2.2
• dependabot/pip/django-celery-beat-1.5.0
• dependabot/pip/django-extensions-2.1.7
• dependabot/pip/kombu-4.6.0
• dependabot/pip/markdown-3.1.1
• dependabot/pip/openpyxl-2.6.2
• dependabot/pip/pillow-6.2.0
• dependabot/pip/requests-2.22.0
• dependabot/pip/sentry-sdk-0.8.0
• dependabot/pip/sentry-sdk-0.9.0
• dependabot/pip/twisted-19.2.1
• dependency-updates
• deploy-feature-branch
• dev-tool-updates-20190607
• difficulty-values
• dismiss-asset-banner
• display-unique-tag-values
• django-settings-rename
• django-setup
• doc-cleanup
• docker-apt-updates
• docker-credentials
• docker-make-dev-settings-overrideable
• ecs-conn-max-age
• elainekamlley-patch-1
• elasticsearch-dsl-update
• enable-new-simplepages
• enable-pre-commit-checks-in-travis
• enable-sonarcloud
• entrypoint-bugfix
• entrypoint-difficulty-values
• es-deployment
• exclude-frontend-from-coveralls
• export-assets
• export-attributions
• export-item-resource-urls
• export-one-page-per-item
• export-to-s3
• extra-flake8-plugins
• feature-gate-social-share
• finish-activity-ui-asset-reservations
• fix-asset-status-display-calculation
• fix-cfn-lint-errors
• fix-coverage-xml-reports
• fix-indexing-task
• fix-latest-transcription-in-bulk-views
• fix-typo-contributing
• flip-button
• follow-django-url-conventions
• frontend-testing
• frontend-updates
• graceful-handling-of-network-errors
• homepage-campaign-display-updates
• homepage-updates
• import-report-data
• importer-memory-limit
• importer-strategy
• improved-asset-detail-responsiveness
• improved-user-profile-contribution-history
• in-progress-bugfix
• increase-anon-ratelimits
• increase-importer-memory
• index-assets
• index-site-reports
• items-with-periods
• jenkins-cloudformation
• keeping-count
• lalgee-mem-day
• latest-update
• letsgo-terrel
• linter-cleanup
• make-ordering-consistent
• management-command-bugfix
• master
• more-api-test-coverage
• more-aria-labels
• more-progress-indicators
• move-help-link
• multiple-project-select-filter
• music-experiment
• new-carousel-slide
• new-es-fields
• no-empty-transcriptions
• npm-updates-20190524
• open-graph-update
• openseadragon-control-overhaul
• optimize-contributor-count-query
• optimize-site-report-admin-display
• optimize-static-assets
• osd-single-tile-source
• pass-active-filters-to-lower-levels
• pass-versions-to-sonarscanner
• preserve-line-breaks-in-descriptions
• print-friendly-transcriptions
• prototype-reservations
• python-dockerfile
• rate-limit-config
• register-duplicate-bugfix
• release
• remove-crowd-prod
• remove-homepage-colons
• remove-imagemin
• remove-indexer-container
• remove-latest-page
• remove-maintenance-mode
• remove-plagiarized-password-complexity-code
• remove-unused-campaign-fields
• reopen-asset
• reservation-messages
• revert-multiple-dbs
• review-after-accept
• review-banner
• rstorey-prototype
• scss-cleanup
• seadragon-tooltips
• search-indexing
• secret-key
• self-host-external-js
• send-welcome-email
• sentry-sdks
• set-reply-to-on-contact-emails
• settings-docker-import-path
• simple-content-blocks
• simple-static-pages
• simplify-api-view-endpoints
• simplify-developer-docs
• simplify-sort-options
• single-reservation-modal
• slim-docker-builds
• social-share-asset
• social-share-corners
• status-refactor
• suffrage-carousel
• support-automatic-password-change-flow
• switch-to-python-3.7-base-image
• tag-release-branch
• test-sentry-on-container-launch
• test-suite-cleanup
• thematic-campaigns
• tidying-logging
• top-level-page-descriptions
• topic-filtering
• topic-link-bugfix
• topic-site-reports
• topics-indexing
• transcription-filtering-ui-update
• travis-ci-config
• try-activity-ui-banner
• tweak-activity-ui-messages
• tweak-asset-view-help-text
• tweak-disabled-button-states
• tweak-isort-settings
• update-activity-ui-carousel
• update-admin-user-export-columns
• update-asset-status-messages
• update-base-image-bastion-hosts
• update-campaign-list-progress-calculations
• update-cfn-lint
• update-copy-url-code
• update-cssvars-polyfill
• update-data-load
• update-db-commands
• update-db-scripts
• update-dependencies
• update-developer-docs
• update-docker-compose-app
• update-docker-compose-config
• update-feature-flags
• update-find-next-page-ranking-logic
• update-fontawesome-cdn
• update-homepage-browse-button-colors
• update-homepage-button
• update-homepage-carousel
• update-homepage-carousel-alt-text
• update-homepage-carousel-controls
• update-homepage-carousel-mobile-display
• update-homepage-lets-go-target
• update-jenkins-psycopg2
• update-list-view-responsiveness
• update-pipfile-version-pinning
• update-pre-commit-hooks
• update-python-celery
• update-ratelimit-reason-code
• update-site-on-db-reload
• update-social-sharing
• update-transcription-review-control-display
• update-transcription-review-flow
• update-urllib
• update-username-validation-message
• upgrade-to-django-2.2.2
• upgrade-to-whitenoise-4.1.3
• upload-docs
• use-dates
• use-popover-for-progress-statistics
• user-interaction-tracking
• v0.4.10
• v0.4.11
• v0.4.13
• v0.4.14
• v0.4.15
• v0.4.16
• v0.4.17
• v0.4.18
• v0.4.19
• v0.4.20
• v0.4.21
• v0.4.22
• v0.4.23
• v0.4.24
• v0.4.26
• v0.4.27
• v0.4.28
• v0.4.29
• v0.4.8
• v0.4.9
• v0.5.0
• v0.5.1
• v0.5.10
• v0.5.11
• v0.5.12
• v0.5.13
• v0.5.14
• v0.5.15
• v0.5.2
• v0.5.3
• v0.5.4
• v0.5.5
• v0.5.6
• v0.5.8
• v0.5.9
• version-0-4-8
• welcome-email-links
• welcome-update

Build # 1638

Build Type

Pull #696

travis-ci

Committed by web-flow

Commit Message

Optimize site report tag count queries

This reduces the query count from ~5,500 to ~90

Pull Request Pull Request #696: Optimize site report tag count queries

Run Details

201 of 404 branches covered (49.75%)

Branch coverage included in aggregate %.

6 of 6 new or added lines in 1 file covered. (100.0%)

1967 of 2697 relevant lines covered (72.93%)

3.65 hits per line