Data & Devrvats20.hashnode.dev·Dec 9, 2024Mastering Database Performance: 10 Key Query Optimization TechniquesOptimizing query performance is a crucial aspect of database design and maintenance. Here are ten effective techniques to improve query performance, along with explanations, use cases, and code samples. 1. Indexing Indexing allows the database system...DiscussSQL seriesSQL
Godwin Lawalgodwinlawal.hashnode.dev·Dec 1, 2024Are Your Database Queries Costing The Business Time and Revenue?Why Should You Care The performance of a business website or application can determine if a company gains or loses customers. Customer expectations are rising, so every part, including the database design, must be optimized to meet these expectations...Discuss·37 readsdatabase administration
Alexander Arlund Nørgaardblog.alexnorgaard.dk·Nov 3, 2024Building an Events Application: Querying events and indexing with GINIn my last blog post we explored how to expose a simple API using the Echo Go framework and GORM ORM. We also took a look at how I wanted to represent an event in the database, including using tags and geolocation for search and filtering purposes. G...DiscussPostgreSQL
Saby_Explainsabyexplain.hashnode.dev·Oct 25, 2024Remedy for Poor-Performing SQL QueriesIn previous posts, we introduced you to Saby Explain, a public service for the analysis and visualization of PostgreSQL query plans. Several months after the launch we've reached the milestone of 6,000 usages, but one of the helpful features sometime...DiscussPostgreSQL
Saby_Explainsabyexplain.hashnode.dev·Oct 24, 2024Best Practices for Bulk Optimization of Queries in PostgreSQLAfter reading this article, you’ll learn about the techniques we use to analyze SQL query performance when dealing with millions of queries per day and monitoring hundreds of PostgreSQL servers. We’ll talk about Saby Explain, a tool that helps us han...DiscussPostgreSQL
Saby_Explainsabyexplain.hashnode.dev·Oct 23, 2024Decoding EXPLAIN: How to Uncover Its Hidden MessagesThis standard question always comes up when developers and business owners consult with database administrators or PostgreSQL experts. It sounds like, “Why do database queries take so long?” These are the most common whys: ineffective query algorith...Discusspostgres
OBULIPURUSOTHAMAN Kobulipurusothaman.hashnode.dev·Oct 22, 2024Sql (vs) NosqlSQL (VS) NOSQL :One of the biggest decisions we make while designing a system is choosing between a Relational (SQL) or Non-Relational (NoSQL) database. Both have their strengths and use cases, but they differ significantly in their approach to data ...DiscussSQL
Nihira Shitapsql-for-the-data-driven-world.hashnode.dev·Oct 8, 2024Best Practices : Know the SQL commands for Data ManagementIn today's data-driven world, the ability to manage, manipulate, and analyze vast amounts of data is a critical skill. SQL (Structured Query Language) is the backbone of database management systems (DBMS), empowering data professionals to extract mea...Discuss#SQLIndexing
Omar Ashouromarashour.hashnode.dev·Oct 1, 2024Database indexingWhen it comes to database performance, optimized and fast queries are essential for efficient data retrieval and manipulation. In today's data-driven world, where applications often handle massive amounts of information, the speed at which a database...Discuss·1 like·82 readsSQL
Rajat Srivastavastackup.hashnode.dev·Sep 15, 2024Efficient Database Lookups: Checking if Email Exists in Millions of RecordsIntroduction Imagine this: Your apps user base has grown rapidly overnight. Suddenly, your fast user registration system is slowing down. The problem? A simple email check to see if a new user's email is already in the database. What used to take mil...Discussbackend
