What is the recommended batch size for database operations?

For standard database inserts, a batch size of 100 to 1000 items is typically recommended to balance performance gains with memory constraints.

Can it handle external API calls?

Yes, it flags individual HTTP requests in loops and suggests batching techniques to reduce network latency and total round trips to external services.

What types of PHP performance issues does this skill detect?

It detects single-item database operations, individual API calls in loops, excessive transaction overhead, and inefficient cache or file system writes.

Does it support Doctrine ORM?

Yes, it specifically includes detection patterns for Doctrine's persist and flush operations, including memory management strategies like clearing the EntityManager.

How does it help with database optimization?

It identifies code that performs one query per loop iteration and provides refactoring examples for bulk inserts and single-flush patterns using PDO or Doctrine.

PHP Batch Processing Optimizer

Name: PHP Batch Processing Optimizer
Author: dykyi-roman

bydykyi-roman

•

数据库管理

Identifies and refactors inefficient PHP loops that perform repetitive database, API, and file operations into high-performance batch processes.

This Claude Code skill analyzes PHP source code to detect common performance bottlenecks where operations are performed one-by-one inside loops. It identifies critical issues like N+1 database queries, individual API calls, and excessive transaction overhead. By providing optimized code patterns for bulk inserts, batch API requests, and memory-efficient chunking, this tool helps developers drastically reduce network round trips and execution time in enterprise-grade PHP applications. It is an essential utility for maintaining high-performance PHP architecture and clean code standards.

主要功能

01Detects individual database inserts and updates inside loops.

0245 GitHub stars

03Identifies costly HTTP/API requests performed per-item in collections.

04Provides severity-classified output with optimized code refactoring examples.

05Analyzes transaction overhead and suggests chunked transaction patterns.

06Flags inefficient cache and file system operations using individual writes.

使用场景

01Optimizing data migration scripts or bulk import utilities.

02Refactoring legacy PHP applications to reduce database server load and latency.

03Improving application response times when integrating with external third-party APIs.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dykyi-roman/awesome-claude-code check-batch-processing

For use in Claude.ai and ChatGPT

Download Skill