---
title: "#databaseoptimization articles | Hashnode"
description: "Explore 14 articles tagged #databaseoptimization on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/databaseoptimization"
---

Tag

# #databaseoptimization

14 posts · 0 followers

[Doogal Simpson](https://hashnode.com/@doogal) · [Mar 28](https://hashnode.com/posts/beyond-the-haversine-formula-why-i-use-geohashing-for-spatial-search/69c7c2f77cf27065100f2325)

### [Beyond the Haversine Formula: Why I Use Geohashing for Spatial Search](https://doogal.dev/beyond-the-haversine-formula-why-i-use-geohashing-for-spatial-search?utm_source=hashnode&utm_medium=feed)

Naive geospatial queries don't scale. Learn how geohashing uses prefix matching to replace expensive geometry calculations with fast database lookups.

5 min read · [doogal.dev](https://doogal.dev/beyond-the-haversine-formula-why-i-use-geohashing-for-spatial-search?utm_source=hashnode&utm_medium=feed)

[Johnny Hideki Kinoshita de Faria](https://hashnode.com/@johnnyhideki) · [Sep 17, 2025](https://hashnode.com/posts/performance-and-tuning-in-plsql-oracle-from-beginner-to-advanced/68cab3f8b70241aefc7ec125)

### [Performance and Tuning in PL/SQL Oracle: From Beginner to Advanced](https://johnnyhideki.hashnode.dev/performance-and-tuning-in-plsql-oracle-from-beginner-to-advanced?utm_source=hashnode&utm_medium=feed)

Optimize Oracle PL/SQL: from basics to advanced techniques for efficient, scalable code

7 min read · [johnnyhideki.hashnode.dev](https://johnnyhideki.hashnode.dev/performance-and-tuning-in-plsql-oracle-from-beginner-to-advanced?utm_source=hashnode&utm_medium=feed)

[Sofiya Parvez Pathan](https://hashnode.com/@sfy) · [Jun 14, 2025](https://hashnode.com/posts/clickhouse-the-columnar-powerhouse-for-real-time-analytics/684d82697326833861ec7506)

### [ClickHouse: The Columnar Powerhouse for Real-Time Analytics](https://clickhouse-sfy.hashnode.dev/clickhouse-the-columnar-powerhouse-for-real-time-analytics?utm_source=hashnode&utm_medium=feed)

In today’s data-driven world, the demand for high-performance, low-latency analytics systems has grown exponentially. Traditional databases often crumble under the weight of massive data volumes. Enter ClickHouse: an open-source, high-performance, co...

5 min read · [clickhouse-sfy.hashnode.dev](https://clickhouse-sfy.hashnode.dev/clickhouse-the-columnar-powerhouse-for-real-time-analytics?utm_source=hashnode&utm_medium=feed)

[Huy Nguyen](https://hashnode.com/@huycommit) · [Apr 24, 2025](https://hashnode.com/posts/wal-trong-postgresql/680a518313411293400278ca)

### [WAL trong Postgresql](https://huycommit.hashnode.dev/wal-trong-postgresql?utm_source=hashnode&utm_medium=feed)

Tiếp nối bài WAL, hôm nay mình sẽ nói cụ thể hơn về WAL trong Postgesql WAL là gì Giúp khôi phục database khi Postgresql bị shutdown đột ngột Các cơ sở dữ liệu đều có các khái niệm tương đương với WAL trong Postgresql, ví dụ: Transaction log (SQL S...

2 min read · [huycommit.hashnode.dev](https://huycommit.hashnode.dev/wal-trong-postgresql?utm_source=hashnode&utm_medium=feed)

[Manoj Kumar](https://hashnode.com/@Manoj8222) · [Apr 19, 2025](https://hashnode.com/posts/system-design-day-3/6803b20ce91585456f691a3b)

### [System Design (Day 3)](https://systemdesignbymanoj.hashnode.dev/system-design-day-3?utm_source=hashnode&utm_medium=feed)

Database Sharding Database sharding is a horizontal scaling(partitioning) technique that partitions a logical dataset into multiple smaller, independent databases, like customers with ZIP codes less than 50000 are stored in CustomersEast database ins...

2 min read · [systemdesignbymanoj.hashnode.dev](https://systemdesignbymanoj.hashnode.dev/system-design-day-3?utm_source=hashnode&utm_medium=feed)

[Huy Nguyen](https://hashnode.com/@huyandres2001) · [Apr 5, 2025](https://hashnode.com/posts/he-thong-hinh-nhu-cham-nhung-toi-khong-biet-cham-o-dau/67f15e2b79e1d8bc7f04bb5b)

### [Hệ thống "hình như" chậm, nhưng tôi không biết chậm ở đâu](https://huyandres2001.hashnode.dev/he-thong-hinh-nhu-cham-nhung-toi-khong-biet-cham-o-dau?utm_source=hashnode&utm_medium=feed)

Xin chào ace! Mình là Huy, một backend dev với 2+ năm kinh nghiệm. Nay mình lại ngoi lên viết bài sau một thời gian ngụp lặn :D TL; DR Bài viết chia sẻ việc tác giả cài đặt các cơ chế logging ghi lại thời gian query trên ứng dụng Spring Boot và theo ...

13 min read · [huyandres2001.hashnode.dev](https://huyandres2001.hashnode.dev/he-thong-hinh-nhu-cham-nhung-toi-khong-biet-cham-o-dau?utm_source=hashnode&utm_medium=feed)

[Abhishek Yadav](https://hashnode.com/@AbhishekYadav) · [Mar 16, 2025](https://hashnode.com/posts/how-i-optimised-database-query-time-by-80-with-smart-indexing/67d6bfd437359309b33e5723)

### [How I Optimised Database Query Time by 80% with Smart Indexing?](https://blog.abhishekyadav.top/how-i-optimised-database-query-time-by-80-with-smart-indexing?utm_source=hashnode&utm_medium=feed)

How to Optimised Database Query Time by 80% with Smart Indexing.

1 min read · [blog.abhishekyadav.top](https://blog.abhishekyadav.top/how-i-optimised-database-query-time-by-80-with-smart-indexing?utm_source=hashnode&utm_medium=feed)

[Huy Nguyen](https://hashnode.com/@huyandres2001) · [Feb 11, 2025](https://hashnode.com/posts/danh-index-dung-chi-dua-vao-dieu-kien-where/67aaddecf45714909195acb6)

### [Đánh index đừng chỉ dựa vào điều kiện WHERE!!!](https://huyandres2001.hashnode.dev/danh-index-dung-chi-dua-vao-dieu-kien-where?utm_source=hashnode&utm_medium=feed)

Liệu có còn yếu tố gì ảnh hưởng đến câu lệnh query ngoài điều kiện WHERE không nhỉ?

6 min read · [huyandres2001.hashnode.dev](https://huyandres2001.hashnode.dev/danh-index-dung-chi-dua-vao-dieu-kien-where?utm_source=hashnode&utm_medium=feed)

[Huy Nguyen](https://hashnode.com/@huyandres2001) · [Feb 8, 2025](https://hashnode.com/posts/dev-quen-hoc-cach-dung-index-trong-db/67a79e16ef1ea3f2c4b7c2f8)

### [Dev quèn học cách dùng index trong DB](https://huyandres2001.hashnode.dev/dev-quen-hoc-cach-dung-index-trong-db?utm_source=hashnode&utm_medium=feed)

Hôm nay là một ngày đẹp trời, và không vì lí do gì cả, hãy cùng nhau tìm hiểu một số tình huống thường gặp với index trong Oracle DB và xem cách tối ưu query như thế nào nhé. Chỉ cần sai một chút, query của bạn có thể mất cả phút để chạy, hay nặng hơ...

8 min read · [huyandres2001.hashnode.dev](https://huyandres2001.hashnode.dev/dev-quen-hoc-cach-dung-index-trong-db?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/dev-quen-hoc-cach-dung-index-trong-db/67a79e16ef1ea3f2c4b7c2f8)

[Huy Nguyen](https://hashnode.com/@huycommit) · [Feb 8, 2025](https://hashnode.com/posts/how-db-decide-to-choose-execution-plan/67a726f9246888faa6166bb9)

### [Làm cách nào để database đưa ra quyết định sử dụng index hay không](https://huycommit.hashnode.dev/how-db-decide-to-choose-execution-plan?utm_source=hashnode&utm_medium=feed)

Cách database dùng statistic để đưa ra quyết định khi dùng index

3 min read · [huycommit.hashnode.dev](https://huycommit.hashnode.dev/how-db-decide-to-choose-execution-plan?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/how-db-decide-to-choose-execution-plan/67a726f9246888faa6166bb9)
