This page lists Looker documentation pages that include information about optimizing Looker performance.
Overview
The following page provides a high-level view of issues that can affect Looker performance.
Dashboard performance
The following page provides tips on how to design Looker dashboards to optimize performance.
Query performance
The following pages provide information on how to design LookML models to optimize query performance.
- Optimize query performance
- Caching queries
- Aggregate awareness
- Aggregate awareness tutorial
- Accelerate your queries with Looker aggregate awareness
- Incremental PDTs
- How to Optimize SQL with EXPLAIN
- suggestions (for fields)
Instance performance
This section includes information on ways Looker admins can optimize the Looker instance.
- Optimize Looker server performance
- Designing your Looker deployment for scale
- Max number of PDT builder connections
- Fetch Information Schema For SQL Writing
Customer-hosted instances
This section includes performance information that is specific to customer-hosted instances.
Database performance
This section includes both general and dialect-specific information about optimizing database performance for use with Looker.
BigQuery
Amazon Redshift
Amazon RDS for MySQL
Performance monitoring
This section includes information about how to monitor the performance of a Looker instance.