Databases

Table design, indexes and fast queries in MySQL.

2 Article

Step-by-step tutorial Databases

MySQL Indexes: Speed Up Slow Queries

The right index can turn a multi-second query into a few milliseconds, but the wrong index only adds size and slows writes. This article uses EXPLAIN to show where an index is needed and how to create it.

Sep 14, 2026 4 min read

Comprehensive guide Databases

Designing Database Tables for a Web Project

Poorly designed tables charge you later on every report and every change. This guide shows the practical principles: finding entities, primary and foreign keys, sensible normalization, choosing data types and a simple shop example.

Sep 10, 2026 4 min read