optimization – ITFROMZERO – Share tobe shared!

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.

Docker

Optimize Docker Images 30x with DockerSlim (Without Touching the Dockerfile)

By admin May 28, 2026

The era of bloated Docker images is over. This guide shows you how to use DockerSlim to automatically shrink container sizes by 30x, speeding up deployment and tightening security.

Linux

Saving RAM on Linux Servers with systemd Socket Activation

By admin May 24, 2026

Learn how to optimize Linux server RAM using systemd Socket Activation. This technique ensures services only start on demand, reducing resource usage and speeding up boot times.