optimization – ITFROMZERO – Share tobe shared!

Development tutorial - IT technology blog

Handling 100,000 Rows of Data Smoothly in React with react-window

By admin August 12, 2026

Learn how to handle lists with thousands of rows in React without browser lag. A guide to using react-window to optimize DOM nodes and boost rendering speed.

Fedora

Mastering systemd-oomd on Fedora: Rescuing Your PC from RAM-Related Freezes

By admin August 10, 2026

No more system freezes on Fedora by mastering systemd-oomd. A detailed guide on configuring PSI, Swap limits, and protecting critical apps during RAM exhaustion.

MySQL

Implementing Soft Delete in MySQL: Don’t Let Unique Constraints and Indexes Slow You Down

By admin August 8, 2026

Soft Delete is more than just adding a Boolean column. Discover how to handle Unique Constraints using Virtual Columns and optimize indexes for large databases based on real-world experience.

MySQL

Is MySQL COUNT(*) Slow? Don’t Let Your Dashboard Freeze When Data Hits Millions of Rows

By admin July 30, 2026

Why does MySQL COUNT(*) slow down on large InnoDB datasets? This article analyzes the impact of MVCC and provides 4 optimization techniques using Counter Tables, Metadata, and Redis.

Python

Mastering Python functools: Writing Better, Faster Code

By admin July 25, 2026

Stop letting your Python code lag due to redundant calculations. Discover how to use lru_cache, singledispatch, and partial in the functools library to optimize performance and clean up your code today.

Git

Guide to Using git-sizer: “Rescuing” Bloated and Sluggish Git Repositories

By admin July 22, 2026

Is a bloated Git repo slowing down your team? Learn how to use git-sizer to find junk files, massive blobs, and the most effective ways to optimize Git history.

MySQL

Optimizing MySQL Storage: Choosing the Right Data Types to Speed Up I/O and Save RAM

By admin June 26, 2026

Choosing the wrong MySQL data types causes unnecessarily bloated databases, high I/O, and wasted RAM. This article shares real-world experience from a 50GB production database: how to choose correctly between INT/BIGINT, VARCHAR/TEXT, ENUM, and TIMESTAMP to optimize performance right from schema design.

Docker

Professional Production Dockerization for Laravel: Multi-stage Build, Worker, and Scheduler

By admin June 22, 2026

Learn how to professionally Dockerize Laravel using Multi-stage builds. Isolate PHP-FPM, Nginx, Worker, and Scheduler to optimize performance and image size for production.

Python

Optimizing Python RAM with slots: Secrets to Handling Millions of Objects Without Memory Overflow

By admin June 8, 2026

Struggling with Python's high RAM usage? Discover how to use __slots__ to save up to 70% memory when handling large datasets. Practical techniques to keep your application running smoothly with millions of objects.

Artificial Intelligence tutorial - IT technology blog

GPTCache: The Secret to Reducing OpenAI Bills by 80% and Speeding Up AI App Responses

By admin June 8, 2026

Are your OpenAI API bills too high? Learn how to configure GPTCache to reduce costs by 80% and slash AI response times to milliseconds using Semantic Caching.