indexing

2 posts tagged with this topic

April 16, 2026

Evaluate Index Strategies Beyond Big-O Complexity

Explores why theoretical data structures faster than O(log n) rarely outperform the practical, hardware-conscious index types used in modern databases.

database indexing algorithm performance mysql postgresql b-tree backend big-o

April 14, 2026

Moving from MySQL JSON to Postgres arrays

Transitioning from JSON columns to native Postgres arrays provides a more efficient approach for handling simple list-based data structures through indexing and direct querying.

mysql postgresql database schema optimization array json indexing performance