--- title: SQL performance improvements: finding the right queries... description: A case study from Oh Dear showing how Mattias significantly improved service performance through SQL query optimization. The post focuses on identifying and... canonical: https://daily.dev/posts/ibrcn2fnl twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: SQL performance improvements: finding the right queries to fix | daily.dev og:description: A case study from Oh Dear showing how Mattias significantly improved service performance through SQL query optimization. The post focuses on identifying and... og:url: https://daily.dev/posts/ibrcn2fnl og:image: https://api.daily.dev/og/posts/IBRcn2FnL.png og:image:alt: Post cover image og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # SQL performance improvements: finding the right queries to fix **[DevShareVietNam](https://daily.dev/sources/devsharevietnam)** · [@hoanguyencoder](https://daily.dev/hoanguyencoder) · 55 upvotes · 2 comments ## Summary A case study from Oh Dear showing how Mattias significantly improved service performance through SQL query optimization. The post focuses on identifying and fixing the right queries to achieve substantial performance gains. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Community discussion Top comments from developers on daily.dev. **@linhvuquach** · 0 upvotes > cool, thank bro **@rrdiegoisaac** · 0 upvotes > Thanks, i learned a lot ## Similar posts on daily.dev - [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 1 upvotes · 0 comments - [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments - [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments - [CNCF Unveils Schedule for KubeCon \+ CloudNativeCon Europe 2026](https://daily.dev/posts/cncf-unveils-schedule-for-kubecon-cloudnativecon-europe-2026-ikhcoa5cb) · CNCF · 2 upvotes · 0 comments - [CNCF Debuts KubeCon \+ CloudNativeCon Japan 2026 Schedule](https://daily.dev/posts/cncf-debuts-kubecon-cloudnativecon-japan-2026-schedule-xp5pyudub) · CNCF · 1 upvotes · 0 comments --- Tags: [#performance](https://daily.dev/tags/performance), [#database](https://daily.dev/tags/database), [#sql](https://daily.dev/tags/sql) [View this post on daily.dev](https://daily.dev/posts/ibrcn2fnl) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"DiscussionForumPosting","mainEntityOfPage":"https://daily.dev/posts/ibrcn2fnl","headline":"SQL performance improvements: finding the right queries to fix","text":"Shared: SQL performance improvements: finding the right queries to fix","url":"https://daily.dev/posts/ibrcn2fnl","datePublished":"2025-11-02T15:35:24.873Z","dateModified":"2025-11-02T15:35:24.874Z","author":{"@type":"Person","name":"Hòa Nguyễn Coder","url":"https://daily.dev/hoanguyencoder","image":"https://media.daily.dev/image/upload/s--SCsZnAEj--/f_auto/v1751094071/avatars/avatar_hv0ugE9ii7tYkZ7uDsO6N?_a=BAMClqZW0","description":"Web Developer","interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"EndorseAction"},"userInteractionCount":1610}},"image":"https://media.daily.dev/image/upload/s--P4t4XyoV--/f_auto/v1722860399/public/Placeholder%2001","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":55},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":2}],"sharedContent":{"@type":"WebPage","url":"https://api.daily.dev/r/ZJ6rDzSNX"},"comment":[{"@type":"Comment","text":"cool, thank bro","datePublished":"2025-11-13T07:50:44.342Z","url":"https://daily.dev/posts/IBRcn2FnL#c-pYzWNCWjm","author":{"@type":"Person","name":"linh.vu.quach","url":"https://daily.dev/linhvuquach","image":"https://media.daily.dev/image/upload/s--kEYiRGxG--/f_auto/v1763954502/avatars/avatar_G2AMVIL16cHWe6xt3TwGc?_a=BAMAK+ZW0"}},{"@type":"Comment","text":"Thanks, i learned a lot","datePublished":"2025-11-12T12:50:45.302Z","url":"https://daily.dev/posts/IBRcn2FnL#c-0Bx88nXl1","author":{"@type":"Person","name":"Diego Isaac","url":"https://daily.dev/rrdiegoisaac","image":"https://avatars.githubusercontent.com/u/164385592?v=4"}}],"isPartOf":{"@type":"WebPage","url":"https://daily.dev/squads/devsharevietnam","name":"DevShareVietNam"}} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"DevShareVietNam","item":"https://daily.dev/squads/devsharevietnam"},{"@type":"ListItem","position":3,"name":"SQL performance improvements: finding the right queries to fix"}]} ```