# Shopify's Path to a Faster Trino Query Execution: Infrastructure

DevFeed: [Shopify's Path to a Faster Trino Query Execution: Infrastructure](<https://devfeed.tech/articles/shopify-s-path-to-a-faster-trino-query-execution-infrastructure-1388.md>)

Original publisher: [Read original article](<https://shopify.engineering/faster-trino-query-execution-infrastructure>)

Author: Matthew Bruce

Published: 2021-07-09T14:30:02Z

Content type: article

Language: en

Sources: [Shopify Engineering](<https://devfeed.tech/sources/shopify-engineering.md>), [Shopify Engineering - Shopify Engineering](<https://devfeed.tech/sources/shopify-engineering-shopify-engineering.md>)

Topics: [AI, ML & Data Engineering](<https://devfeed.tech/topics/ai-ml-data-engineering.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [datasets](<https://devfeed.tech/tags/datasets.md>), [deployment](<https://devfeed.tech/tags/deployment.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [scale](<https://devfeed.tech/tags/scale.md>), [shopify](<https://devfeed.tech/tags/shopify.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

Shopify describes scaling its Trino-based interactive query infrastructure for a growing data lake, targeting query execution times below five seconds. The excerpt outlines separate scheduled and ad hoc clusters, gateway-based routing, and Kubernetes deployment.

## Source excerpt

We'll discuss how we scaled our interactive query infrastructure to handle the rapid growth of our datasets, while enabling a query execution time of less than 5 seconds.