Moe Abbasmoeabbas.hashnode.dev·Apr 28, 2024How to Find Costly Queries with a Simple ViewThe information schema is a powerful resource that can be used to find detailed information about everything from tables and columns to, you guessed it, jobs and query costs. Today, we'll crack open the jobs section and use it to sniff out costly que...DiscussBigQuerybigquery
Gowtham Kumartechwebsite.tech·Apr 24, 2024Fix Laravel (N+1) Query ProblemFight the problem of too many (N+1) SQL queries, on THREE levels. 1. FIND & fix them: with Debugbar https://github.com/barryvdh/laravel-debugbar 2. AVOID them: learn to use Eager Loading https://laravel.com/docs/11.x/eloquent-relationships#eager-load...DiscussWeb Performance Optimization -- Best Practices & Tipsoptimization
Diptarup Mukherjeediptarup.hashnode.dev·Apr 14, 2024Optimizing SQL query performance:In order to understand the optimization of SQL queries first we need to understand what actually happens in the background when we query our database table. So grab a cup of coffee and lets start our discussion by considering a scenario. All query ex...DiscussDatabases
kalam ahmedkalam714.hashnode.dev·Apr 2, 2024Enhancing Database Query Performance with Advanced Laravel Eloquent TechniquesAs a chef, you know that ingredient quality significantly affects the flavor of your dishes. Similarly, in web development, optimizing your database queries is like using top-notch ingredients to boost your recipe’s performance. Imagine you’re cookin...Discuss·10 likesAdvanced Techniques
Asfia Aimanasfiaaiman.hashnode.dev·Feb 29, 2024Maximizing Laravel Query Execution Efficiency: Unleashing Speed and PrecisionIntroduction In the dynamic realm of web development, speed is paramount. A rapid Laravel website not only captivates users but also propels you ahead of the competition. This guide serves as your compass for optimizing Laravel queries, ensuring your...Discusslaravel queries
Jeremy DornforGrowthBook Engineering Bloggrowthbook.hashnode.dev·Jan 19, 2024Fact Table Query OptimizationBack in October 2023, GrowthBook 2.5 added support for Fact Tables. This allowed you to write SQL once and re-use it for many related metrics. For example, an Orders fact table being used for Revenue, Average Order Value, and Purchase Rate metrics. H...Discuss·123 readsSQL
Muhammad Sherifmuhammad-sherif.hashnode.dev·Jan 18, 2024Query Execution Part 2: Join Algorithms - Hash JoinIntroduction This article offers an insightful exploration into the inner workings of the Hash join algorithm, explain it's two types one-phass and two-phase hash join, understanding its components in query plans. It delves into a detailed cost analy...Discuss·5 likes·218 readshash join
Rishabh Chandelchandel.hashnode.dev·Jan 1, 2024Boosting PostgreSQL Performance with BRIN IndexesIntroduction PostgreSQL, known for its extensibility and robustness, offers a variety of indexing options to optimize query performance. Among these, Block Range INdexes (BRIN) provide a unique approach to indexing large tables with ranges of values....Discuss·12 likes·189 readsBRINvsBTree
Ian Carsoniancarson.hashnode.dev·Nov 10, 2023Scaling a database and why Sharding is Crucial.Scaling a database is hard and one of the ways of doing it is via Sharding. However, sharding is a complex process. Some companies such as Discord, Notion, and Quora use sharding to scale their databases. Sharding is a database architecture pattern t...DiscussDatabases
Bhavesh Yadavcodezera.hashnode.dev·Sep 27, 2023GraphQL: A Paradigm Shift in API Design 🚀Welcome to the exciting world of GraphQL! Whether you're a seasoned developer or just starting your coding journey, GraphQL is a revolutionary query language that has been gaining tremendous popularity in the field of web development. 💻 In this begi...DiscussGraphQL