performance Archives - Page 2 of 7 - ITFROMZERO

Bringing SQLite to Production: Optimizing WAL Mode and Synchronous for Real-World Loads

By IT From Zero September 16, 2026

SQLite is far from weak if you know how to configure it. Learn how to optimize WAL Mode, Synchronous, and Cache to handle thousands of transactions per second in production environments.

Development

Rust and Axum: Secrets to Building High-Speed Web APIs from Real-World Experience

By IT From Zero September 15, 2026

Learn how to build high-performance Web APIs with Rust and Axum through real-world experience. This guide covers everything from coding and DB connections to optimized Linux deployment.

MySQL

InnoDB Page Compression: A Pro Tip to Reduce Storage by 50% and Extend SSD Lifespan for MySQL

By IT From Zero September 5, 2026

Discover how to use InnoDB Page Compression to reduce MySQL storage by 50%. Detailed guide on configuration, checking actual disk usage, and CPU performance considerations.

Docker

How to Use Mutagen to Speed Up Docker File Sync on Windows and macOS

By IT From Zero August 26, 2026

Docker bind mounts on macOS and Windows are notoriously slow — Mutagen solves this by syncing files via delta-sync into a native container volume, boosting I/O performance by 10–20×. This guide covers installation, mutagen-compose configuration, and practical tips to get the most out of the tool.

MySQL

MySQL: Should You Use UUID or AUTO_INCREMENT? Optimization Strategies with UUID v7

By IT From Zero August 22, 2026

Don't let UUID v4 slow down your database. Discover why UUID v7 is the perfect alternative to AUTO_INCREMENT in large-scale MySQL systems.

Python

Building High-Performance GraphQL APIs with Python and Strawberry

By IT From Zero August 18, 2026

Build high-performance GraphQL APIs with Python, Strawberry, and FastAPI. A detailed guide on using DataLoader to optimize speed and reduce latency from seconds to milliseconds.

Development

Clinic.js: Diagnosing Memory Leaks and Event Loop Lag in Node.js

By IT From Zero August 18, 2026

Explore the Clinic.js toolkit to diagnose memory leaks, event loop lag, and optimize Node.js performance through real-world examples from production environments.

Python

Pushing Python to the Limit with Rust and PyO3: From 15 Minutes to 10 Seconds

By IT From Zero July 29, 2026

Explore how to use PyO3 to speed up Python applications with Rust. A detailed guide from installation to real-world performance optimization for heavy data tasks.

Python

Using itertools to Conquer Big Data: Don’t Let MemoryError Get in Your Way

By IT From Zero July 26, 2026

Don't let MemoryError stop you. Discover how to use itertools to process millions of records efficiently, optimize RAM, and speed up your Python scripts.

Python

MongoDB + Python: From Basic CRUD to Advanced Aggregation with PyMongo

By IT From Zero July 22, 2026

Learn how to connect Python with MongoDB efficiently. This guide covers optimizing CRUD with insert_many, using Aggregation Pipelines, and indexing techniques for big data.