--- title: "#database-indexing articles | Hashnode" description: "Explore 30 articles tagged #database-indexing on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/database-indexing" --- Tag # #database-indexing 30 posts · 0 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) [qodors](https://hashnode.com/@qodors) · [Sep 16](https://hashnode.com/posts/your-app-works-with-100-users-can-it-handle-100-000/6aaa2fa2019ffdc9eff872fe) ### [Your App Works With 100 Users. Can It Handle 100,000?](https://qodors.hashnode.dev/your-app-works-with-100-users-can-it-handle-100-000?utm_source=hashnode&utm_medium=feed) How database indexing and query optimization help your app handle growing datasets. 9 min read · [qodors.hashnode.dev](https://qodors.hashnode.dev/your-app-works-with-100-users-can-it-handle-100-000?utm_source=hashnode&utm_medium=feed) [Lakshay Dhoundiyal](https://hashnode.com/@LakshayDhoundiyal) · [Sep 12](https://hashnode.com/posts/youtubes-continue-watching-button/6aa5471c3b396c9a7c4ddbf5) ### [The Hidden Distributed System Behind YouTube’s “Continue Watching” Button 🎬⚙️](https://lakshaydhoundiyal.hashnode.dev/youtubes-continue-watching-button?utm_source=hashnode&utm_medium=feed) How YouTube saves your playback progress, syncs it across devices, and makes one tiny timestamp feel like magic 10 min read · [lakshaydhoundiyal.hashnode.dev](https://lakshaydhoundiyal.hashnode.dev/youtubes-continue-watching-button?utm_source=hashnode&utm_medium=feed) [Lakshay Dhoundiyal](https://hashnode.com/@LakshayDhoundiyal) · [Sep 4](https://hashnode.com/posts/how-does-gmail-know-a-username-is-already-taken/6a9a6e26433fabf5fd357eb2) ### [How Does Gmail Know a Username Is Already Taken in Milliseconds?](https://lakshaydhoundiyal.hashnode.dev/how-does-gmail-know-a-username-is-already-taken?utm_source=hashnode&utm_medium=feed) The system-design concepts behind username availability checks, database indexing, caching, APIs, and low-latency distributed systems 10 min read · [lakshaydhoundiyal.hashnode.dev](https://lakshaydhoundiyal.hashnode.dev/how-does-gmail-know-a-username-is-already-taken?utm_source=hashnode&utm_medium=feed) [Tech Insights Hub](https://hashnode.com/@JohnMikes) · [Feb 26](https://hashnode.com/posts/postgresql-indexing-the-hidden-performance-bottleneck-1-1-1-1-1-1-1-1-1-1/699ffff21f80bea812f9a969) ### [\*\* PostgreSQL Indexing: The Hidden Performance Bottleneck](https://topperblog.hashnode.dev/postgresql-indexing-the-hidden-performance-bottleneck-1-1-1-1-1-1-1-1-1-1?utm_source=hashnode&utm_medium=feed) \*\* Discover why your PostgreSQL queries are slow despite having indexes. Learn advanced indexing strategies, common pitfalls, and optimization techniques. 7 min read · [topperblog.hashnode.dev](https://topperblog.hashnode.dev/postgresql-indexing-the-hidden-performance-bottleneck-1-1-1-1-1-1-1-1-1-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) [Tech Insights Hub](https://hashnode.com/@JohnMikes) · [Feb 23](https://hashnode.com/posts/postgresql-indexing-the-hidden-performance-bottleneck-1-1-1-1-1-1/699cb3165c803883f39b203c) ### [\*\* PostgreSQL Indexing: The Hidden Performance Bottleneck](https://topperblog.hashnode.dev/postgresql-indexing-the-hidden-performance-bottleneck-1-1-1-1-1-1?utm_source=hashnode&utm_medium=feed) \*\* Discover why your PostgreSQL queries are slow despite having indexes. Learn advanced indexing strategies, common pitfalls, and optimization techniques. 6 min read · [topperblog.hashnode.dev](https://topperblog.hashnode.dev/postgresql-indexing-the-hidden-performance-bottleneck-1-1-1-1-1-1?utm_source=hashnode&utm_medium=feed) [Tech Insights Hub](https://hashnode.com/@JohnMikes) · [Feb 23](https://hashnode.com/posts/postgresql-indexing-the-hidden-performance-bottleneck-1-1-1-1-1-1-1-1-1/699cd098a4d97e64cb0f9efa) ### [\*\* PostgreSQL Indexing: The Hidden Performance Bottleneck](https://topperblog.hashnode.dev/postgresql-indexing-the-hidden-performance-bottleneck-1-1-1-1-1-1-1-1-1?utm_source=hashnode&utm_medium=feed) \*\* Discover why your PostgreSQL queries are slow despite having indexes. Learn advanced indexing strategies, common pitfalls, and optimization techniques. 6 min read · [topperblog.hashnode.dev](https://topperblog.hashnode.dev/postgresql-indexing-the-hidden-performance-bottleneck-1-1-1-1-1-1-1-1-1?utm_source=hashnode&utm_medium=feed) [Tech Insights Hub](https://hashnode.com/@JohnMikes) · [Feb 23](https://hashnode.com/posts/postgresql-indexing-the-hidden-performance-bottleneck-1-1-1-1-1-1-1-1/699cc77ca4d97e64cb0f9edf) ### [\*\* PostgreSQL Indexing: The Hidden Performance Bottleneck](https://topperblog.hashnode.dev/postgresql-indexing-the-hidden-performance-bottleneck-1-1-1-1-1-1-1-1?utm_source=hashnode&utm_medium=feed) \*\* Discover why your PostgreSQL queries are slow despite having indexes. Learn advanced indexing strategies, common pitfalls, and optimization techniques. 7 min read · [topperblog.hashnode.dev](https://topperblog.hashnode.dev/postgresql-indexing-the-hidden-performance-bottleneck-1-1-1-1-1-1-1-1?utm_source=hashnode&utm_medium=feed) [Tech Insights Hub](https://hashnode.com/@JohnMikes) · [Feb 23](https://hashnode.com/posts/postgresql-indexing-the-hidden-performance-bottleneck-1-1-1-1-1-1-1/699cc05c41507b4062c4c0a3) ### [\*\* PostgreSQL Indexing: The Hidden Performance Bottleneck](https://topperblog.hashnode.dev/postgresql-indexing-the-hidden-performance-bottleneck-1-1-1-1-1-1-1?utm_source=hashnode&utm_medium=feed) \*\* Discover why your PostgreSQL queries are slow despite having indexes. Learn advanced indexing strategies, common pitfalls, and optimization techniques. 7 min read · [topperblog.hashnode.dev](https://topperblog.hashnode.dev/postgresql-indexing-the-hidden-performance-bottleneck-1-1-1-1-1-1-1?utm_source=hashnode&utm_medium=feed)