# Shopify's Path to a Faster Trino Query Execution: Custom Verification, Benchmarking, and Profiling Tooling

DevFeed: [Shopify's Path to a Faster Trino Query Execution: Custom Verification, Benchmarking, and Profiling Tooling](<https://devfeed.tech/articles/shopify-s-path-to-a-faster-trino-query-execution-custom-verification-benchmarking-and-profiling-tooling-1389.md>)

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

Author: Noam Hacker

Published: 2021-10-27T18:27:09Z

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: [data](<https://devfeed.tech/topics/data.md>)

Tags: [benchmarking](<https://devfeed.tech/tags/benchmarking.md>), [data](<https://devfeed.tech/tags/data.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [scale](<https://devfeed.tech/tags/scale.md>), [shopify](<https://devfeed.tech/tags/shopify.md>), [sql](<https://devfeed.tech/tags/sql.md>), [testing](<https://devfeed.tech/tags/testing.md>), [tooling](<https://devfeed.tech/tags/tooling.md>)

## AI overview

Shopify describes custom verification, benchmarking, and profiling tooling used to assess Trino changes before they affect a large data-querying cluster. The goal is to reduce the operational risk of infrastructure optimizations and software updates while improving query execution time.

## Source excerpt

Shopify's Data Reliability team built custom verification, benchmarking, and profiling tooling for testing and analyzing Trino. Our tooling is designed to minimize the risk of various changes at scale.