performance Archives - ITFROMZERO

Processing Parquet Files in Python with PyArrow: Reading, Writing, and Production Optimization Tips

By IT From Zero October 27, 2026

Six months of production experience using PyArrow and Apache Parquet in Python: resolving VPS OOM errors, slashing log storage from 12GB to 1.4GB, and cutting processing time from 18 minutes to 42 seconds.

Python

Optimizing Python Performance with Pyinstrument: Pinpointing Real-World Bottlenecks Without Slowing Down Your System

By IT From Zero October 20, 2026

A real-world comparison between cProfile and Pyinstrument. Learn how to pinpoint I/O, database, and network bottlenecks in Python with under 5% overhead.

MySQL

Optimizing MySQL Queries with Covering Indexes: The Secret to Eliminating Table Lookups

By IT From Zero October 18, 2026

Table Lookups are the primary cause of I/O bottlenecks on large datasets, even when queries use an index. Master Covering Indexes and Deferred Joins to slash query latency from seconds down to milliseconds.

Python

Load Testing Systems with Locust in Python: Real-World Scenarios and API Metric Analysis

By IT From Zero October 6, 2026

A comprehensive guide on writing API load testing scripts with Locust in Python. Explore comparisons between JMeter, k6, and Locust, and learn how to interpret RPS and 95th percentile latency metrics.

Development

A Complete Guide to Integrating Sentry into Next.js: Catching Runtime Errors and Monitoring Performance from A to Z

By IT From Zero October 4, 2026

Learn how to set up Sentry for full-stack Next.js apps: from a 5-minute wizard setup, capturing Server Action/API errors, and measuring database latency to smart Slack alerts.

Docker

Speed Up Docker Desktop: Configure VirtioFS to Process Thousands of Files in Seconds

By IT From Zero September 27, 2026

Configuring VirtioFS on Docker Desktop boosts file I/O sync speeds by 3-5x. It's the optimal solution to reduce lag and save CPU on Mac and Windows machines.

Development

Kysely: A Query Builder Alternative to Prisma and TypeORM for TypeScript Projects

By IT From Zero September 21, 2026

Kysely is the perfect alternative to Prisma and TypeORM. Learn how to build a high-performance Type-safe SQL Query Builder, reduce server RAM, and optimize your Node.js development workflow.

Database

10ms Search Autocomplete: Mastering Redis Sorted Sets

By IT From Zero September 20, 2026

Stop using SQL LIKE for search features. Learn how to leverage Redis Sorted Sets to build an autocomplete system with sub-10ms response times.

Development

Next.js x Panda CSS: Say Goodbye to “Class Name Torture” with Type-safe CSS-in-JS

By IT From Zero September 19, 2026

Learn how to integrate Panda CSS into Next.js to leverage the power of Type-safe CSS-in-JS with Zero-runtime performance. A perfect Tailwind alternative for modern developers.

Development

Why I Switched from Express to Fastify: Tips to Triple Your Node.js Throughput

By IT From Zero September 18, 2026

Forget Express if you need real performance. Discover how Fastify triples REST API processing speed through JSON Schema and smart routing mechanisms.