Cette section comprend des informations générales et spécifiques au dialecte sur l'optimisation des performances de la base de données pour l'utiliser avec Looker.
Sauf indication contraire, le contenu de cette page est régi par une licence Creative Commons Attribution 4.0, et les échantillons de code sont régis par une licence Apache 2.0. Pour en savoir plus, consultez les Règles du site Google Developers. Java est une marque déposée d'Oracle et/ou de ses sociétés affiliées.
Dernière mise à jour le 2025/09/05 (UTC).
[[["Facile à comprendre","easyToUnderstand","thumb-up"],["J'ai pu résoudre mon problème","solvedMyProblem","thumb-up"],["Autre","otherUp","thumb-up"]],[["Difficile à comprendre","hardToUnderstand","thumb-down"],["Informations ou exemple de code incorrects","incorrectInformationOrSampleCode","thumb-down"],["Il n'y a pas l'information/les exemples dont j'ai besoin","missingTheInformationSamplesINeed","thumb-down"],["Problème de traduction","translationIssue","thumb-down"],["Autre","otherDown","thumb-down"]],["Dernière mise à jour le 2025/09/05 (UTC)."],[],[],null,["# Looker performance documents\n\nThis page lists Looker documentation pages that include information about optimizing Looker performance.\n\nOverview\n--------\n\nThe following page provides a high-level view of issues that can affect Looker performance.\n\n- [Performance overview](/looker/docs/best-practices/how-to-optimize-looker-performance)\n\nDashboard performance\n---------------------\n\nThe following page provides tips on how to design Looker dashboards to optimize performance.\n\n- [Considerations when building performant Looker dashboards](/looker/docs/best-practices/considerations-when-building-performant-dashboards)\n\nQuery performance\n-----------------\n\nThe following pages provide information on how to design LookML models to optimize query performance.\n\n- [Optimize query performance](/looker/docs/best-practices/how-to-optimize-looker-server-performance#optimize-query-performance)\n- [Caching queries](/looker/docs/caching-and-datagroups)\n- [Aggregate awareness](/looker/docs/aggregate_awareness)\n- [Aggregate awareness tutorial](/looker/docs/best-practices/aggregate-awareness-tutorial)\n- [Accelerate your queries with Looker aggregate awareness](https://cloud.google.com/blog/products/data-analytics/accelerate-queries-looker-aggregate-awareness)\n- [Incremental PDTs](/looker/docs/incremental-pdts)\n- [How to Optimize SQL with EXPLAIN](https://www.googlecloudcommunity.com/gc/Technical-Tips-Tricks/How-to-Optimize-SQL-with-EXPLAIN/ta-p/587526)\n- [suggestions (for fields)](/looker/docs/reference/param-field-suggestions)\n\nInstance performance\n--------------------\n\nThis section includes information on ways Looker admins can optimize the Looker instance.\n\n- [Optimize Looker server performance](/looker/docs/best-practices/how-to-optimize-looker-server-performance#optimize-looker-server-performance)\n- [Max number of PDT builder connections](/looker/docs/connecting-to-your-db#max_number_of_pdt_builder_connections)\n- [Fetch Information Schema For SQL Writing](/looker/docs/connecting-to-your-db#fetch_information_schema_for_sql_writing)\n\n### Customer-hosted instances\n\nThis section includes performance information that is specific to customer-hosted instances.\n\n- [Recommended Java memory settings](/looker/docs/recommended-java-memory-settings)\n- [Migrating the Looker backend database to MySQL](/looker/docs/migrating-looker-backend-db-to-mysql)\n\nDatabase performance\n--------------------\n\nThis section includes both general and dialect-specific information about optimizing database performance for use with Looker.\n\n- [Database connection pooling](/looker/docs/db-connection-pooling)\n\n### BigQuery\n\n- [Job labels and context comments for BigQuery connections](/looker/docs/db-config-google-bigquery#job-labels-and-context-comments-for)\n\n### Amazon Redshift\n\n- [Optionally accessing data in S3 using Amazon Redshift Spectrum](/looker/docs/db-config-amazon-redshift#optionally_accessing_data_in_s3_using_amazon_redshift_spectrum)\n\n### Amazon RDS for MySQL\n\n- [Amazon RDS for MySQL](/looker/docs/db-config-mysql-on-amazon-rds)\n\nPerformance monitoring\n----------------------\n\nThis section includes information about how to monitor the performance of a Looker instance.\n\n- [Understanding query performance metrics](/looker/docs/query-performance-metrics)\n\n### System activity dashboards\n\n- [Database Performance dashboard](/looker/docs/system-activity-dashboards#dashboard_performance_dashboard)\n- [Instance Performance dashboard](/looker/docs/system-activity-dashboards#instance_performance_dashboard)\n- [Performance Recommendations dashboard](/looker/docs/system-activity-dashboards#performance_recommendations_dashboard)\n\n### Looker Marketplace\n\n- [Google BigQuery Performance block](https://marketplace.looker.com/marketplace/detail/datatonic-bq-performance-v2)"]]
