Backend Optimization – ITFROMZERO

MySQL Spatial Data: The Ultimate Guide to Handling GPS Coordinates and Finding Nearby Locations

By admin July 19, 2026

Is calculating GPS distance with DECIMAL slowing down MySQL? Discover how to use Spatial Data, POINT, and Spatial Index to optimize nearby location searches for maximum speed.

Database

Memcached: When to Choose This ‘Veteran’ Over Redis?

By admin June 8, 2026

Memcached remains a top choice for systems requiring massive throughput. Explore installation guides, real-world comparisons with Redis, and security tips to keep your system safe.

Database

PostgreSQL Full-Text Search: High-Performance Vietnamese Search Without Elasticsearch

By admin May 19, 2026

Don't rush to install Elasticsearch! A detailed guide on building high-speed, accurate Vietnamese search directly in PostgreSQL using only tsvector and GIN Index.

MySQL

MySQL 8 CTE: A Professional Solution for Hierarchical Data and Recursive Queries

By admin April 21, 2026

A detailed guide on using CTE and Recursive CTE in MySQL 8 to efficiently handle hierarchical data, replace complex Self-joins, and optimize query performance.