Optimize query performance with LookML, a Case Study

  • 12 August 2015
  • 4 replies
  • 6403 views

Userlevel 3

Query performance is a big part of how customers experience their interaction with data. Looker provides many ways in its modeling layer to optimize for performance. The key to understanding the Looker approach is to first understand where the difference comes from:


Traditional:



  • rewrite the individual query

  • re-tool the db to handle better some of the queries as the issue presents itself


Looker difference:



  • design of how all of the queries will be structured


Basically, as LookML analysts, we have much more context to:



  • how all the pieces relate to each other in our dataset

  • what queries are important/frequent and should be a priority


Because we have more context, we can much better anticipate the needed performance changes depending on the type of dataset. Below is the presentation outlining 3 types of common dataset patterns and how recognizing those patterns helped resolve performance issues.


http://www.slideshare.net/caura_invest_private/performance-tuning-in-database-sql-and-lookml-for-optimal-data-exploration-a-case-study


4 replies

Userlevel 2

Hello @segahm,


It looks as though your link is broken. I’m interested in reading if you’ve time to update it.


Kind regards,

–Thomas

Userlevel 3

Me too.

We currently have the problem that although the DB returns the result of queries in less than 5 seconds, the dashboard needs 10-15 seconds until the queries leave the queued state at all and become “running”.

Your link is not working can you please update it

 

https://dokumen.tips/data-analytics/performance-tuning-in-database-sql-and-lookml-for-optimal-data-exploration.html

Reply