--- title: "#database-optimization articles | Hashnode" description: "Explore 43 articles tagged #database-optimization on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/database-optimization" --- Tag # #database-optimization 43 posts · 1 followers [clixortechnologies](https://hashnode.com/@clixortech) · [Sep 22](https://hashnode.com/posts/how-does-database-architecture-affect-web-application-performance/6ab277cea8ad04f8e300efb5) ### [How Does Database Architecture Affect Web Application Performance?](https://clixortech.hashnode.dev/how-does-database-architecture-affect-web-application-performance?utm_source=hashnode&utm_medium=feed) Learn how database architecture, indexing, queries, and data design affect web application performance and scalability. 5 min read · [clixortech.hashnode.dev](https://clixortech.hashnode.dev/how-does-database-architecture-affect-web-application-performance?utm_source=hashnode&utm_medium=feed) [kiran sabne](https://hashnode.com/@kiransabne) · [Sep 18](https://hashnode.com/posts/postgresql-index-bloat-why-it-happens-and-how-to-fix-it/6aacdb14c88db9c85cde799f) ### [PostgreSQL Index Bloat: Why It Happens and How to Fix It](https://kiransabne.dev/postgresql-index-bloat-why-it-happens-and-how-to-fix-it?utm_source=hashnode&utm_medium=feed) Why PostgreSQL indexes bloat even after VACUUM, how to measure it with pgstatindex, and when to use REINDEX CONCURRENTLY or pg\_repack to fix it. 6 min read · [kiransabne.dev](https://kiransabne.dev/postgresql-index-bloat-why-it-happens-and-how-to-fix-it?utm_source=hashnode&utm_medium=feed) [Tech Vidya](https://hashnode.com/@techvidya0726) · [Aug 28](https://hashnode.com/posts/sql-server-performance-tuning/6a91b84bec3883583130cd26) ### [Sql Server Performance Tuning](https://techvidyaaim.hashnode.dev/sql-server-performance-tuning?utm_source=hashnode&utm_medium=feed) SQL Server is slow. What do you check FIRST? 2 min read · [techvidyaaim.hashnode.dev](https://techvidyaaim.hashnode.dev/sql-server-performance-tuning?utm_source=hashnode&utm_medium=feed) [Yashika Vijayvargiya](https://hashnode.com/@railswithyashika) · [Jun 15](https://hashnode.com/posts/postgresql-concurrent-indexes-in-rails-avoiding-downtime-in-production/6a2fd3d893fd5e9c7afbdf9c) ### [PostgreSQL Concurrent Indexes in Rails: Avoiding Downtime in Production](https://railswithyashika.hashnode.dev/postgresql-concurrent-indexes-in-rails-avoiding-downtime-in-production?utm_source=hashnode&utm_medium=feed) When working with large production databases, adding an index may seem like a simple migration. However, on tables with millions of records, a regular index creation can lock writes and impact your application's availability. 4 min read · [railswithyashika.hashnode.dev](https://railswithyashika.hashnode.dev/postgresql-concurrent-indexes-in-rails-avoiding-downtime-in-production?utm_source=hashnode&utm_medium=feed) [binadit](https://hashnode.com/@binadit) · [Apr 27](https://hashnode.com/posts/how-a-saas-platform-cut-infrastructure-costs-by-40-while-improving-response-times/69ef0f91215f825028dd308b) ### [How a SaaS platform cut infrastructure costs by 40% while improving response times](https://binadit.hashnode.dev/how-a-saas-platform-cut-infrastructure-costs-by-40-while-improving-response-times?utm_source=hashnode&utm_medium=feed) Breaking the performance vs cost trade-off: A SaaS infrastructure optimization case study Infrastructure optimization often feels like a zero-sum game between performance and cost. Faster systems cost more, right? A recent project with a European CRM... 5 min read · [binadit.hashnode.dev](https://binadit.hashnode.dev/how-a-saas-platform-cut-infrastructure-costs-by-40-while-improving-response-times?utm_source=hashnode&utm_medium=feed) [sandeepbansod007](https://hashnode.com/@sandeepbansod) · [Apr 17](https://hashnode.com/posts/we-deployed-a-small-fix-and-took-down-production-here-s-what-actually-happened/69e1f05c9eff9dc9261c20b6) ### [We Deployed a "Small Fix" and Took Down Production — Here's What Actually Happened](https://stackdevlife.hashnode.dev/we-deployed-a-small-fix-and-took-down-production-here-s-what-actually-happened?utm_source=hashnode&utm_medium=feed) A minor backend change caused a production outage, high CPU usage, and API failures. Here's how it happened, what we missed, and how we fixed it. 3 min read · [stackdevlife.hashnode.dev](https://stackdevlife.hashnode.dev/we-deployed-a-small-fix-and-took-down-production-here-s-what-actually-happened?utm_source=hashnode&utm_medium=feed) [PRATIK PATEL](https://hashnode.com/@pratikpatel1015) · [Mar 31](https://hashnode.com/posts/prisma-query-optimization-guide/69cbbddcc1e86567d72b4a45) ### [Prisma N+1 in Production:Real Query Plans and Fixes](https://blog.pratikpatel.pro/prisma-query-optimization-guide?utm_source=hashnode&utm_medium=feed) How a 3-line Prisma query fired 1,847 database queries per request — and how we found, fixed, and prevented it from ever coming back. 6 min read · [blog.pratikpatel.pro](https://blog.pratikpatel.pro/prisma-query-optimization-guide?utm_source=hashnode&utm_medium=feed) [David Shusterman](https://hashnode.com/@davidshusterman) · [Mar 13](https://hashnode.com/posts/why-your-wordpress-site-is-slow-its-not-what-you-think-1/69b3da06e9ea4b56f931cd7b) ### [Why Your WordPress Site Is Slow (It's Not What You Think)](https://davidshusterman.hashnode.dev/why-your-wordpress-site-is-slow-its-not-what-you-think-1?utm_source=hashnode&utm_medium=feed) The real performance killers hiding in your WordPress infrastructure 7 min read · [davidshusterman.hashnode.dev](https://davidshusterman.hashnode.dev/why-your-wordpress-site-is-slow-its-not-what-you-think-1?utm_source=hashnode&utm_medium=feed) [Payal Porwal](https://hashnode.com/@PayalPorwal) · [Feb 24](https://hashnode.com/posts/master-the-top-sql-queries-clear-explanations-practical-examples/699dac5276cf0888f4aef4d4) ### [Master the Top SQL Queries: Clear Explanations + Practical Examples](https://codeswithpayal.hashnode.dev/master-the-top-sql-queries-clear-explanations-practical-examples?utm_source=hashnode&utm_medium=feed) 1️⃣ SELECT (Basic Data Fetching) 🔹 What it does: Fetch data from a table. 🔹 Syntax: SELECT column1, column2 FROM table\_name; 🔹 Example: SELECT name, salary FROM employees; 🔹 Use Case: Showing u 5 min read · [codeswithpayal.hashnode.dev](https://codeswithpayal.hashnode.dev/master-the-top-sql-queries-clear-explanations-practical-examples?utm_source=hashnode&utm_medium=feed) [Aditya Trivedi](https://hashnode.com/@Yuvadi) · [Feb 24](https://hashnode.com/posts/the-thundering-herd-problem-explained/699dbeb1b8de33b11353d7f8) ### [The Thundering Herd Problem: Explained](https://adityatrivedi.hashnode.dev/the-thundering-herd-problem-explained?utm_source=hashnode&utm_medium=feed) Learn what the Thundering Herd problem is, why it crashes databases, and how to fix it using request coalescing, jitter, and locking. A must-know for 6 min read · [adityatrivedi.hashnode.dev](https://adityatrivedi.hashnode.dev/the-thundering-herd-problem-explained?utm_source=hashnode&utm_medium=feed)