---
title: "Once again processing 11 million rows, now in seconds"
url: https://daily.dev/posts/once-again-processing-11-million-rows-now-in-seconds-oqf9cnfsn
source_url: https://stitcher.io/blog/11-million-rows-in-seconds
type: article
source: "stitcher.io"
published: 2026-01-29T11:00:55.669Z
updated: 2026-01-29T11:01:21.011Z
tags: ["performance", "database", "architecture", "php", "mysql"]
reading_time: 10
upvotes: 98
comments: 1
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Once again processing 11 million rows, now in seconds

**[stitcher.io](https://daily.dev/sources/stitcher)** · 10 min read · 98 upvotes · 1 comments

## Summary

A PHP developer optimizes a script processing 11 million database events, improving performance from 50k to 1.7M events per second through incremental changes. Key optimizations include combining SQL inserts, moving calculations from MySQL to PHP, eliminating object instantiation in favor of raw arrays, and removing JSON deserialization by using direct database columns. The journey demonstrates the trade-offs between code convenience and raw performance, with the final implementation processing data in seconds rather than days.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://stitcher.io/blog/11-million-rows-in-seconds>

## Community discussion

Top comments from developers on daily.dev.

**@sam7work** · 2 upvotes

> while the structure and complexity of the data set , and the level of conversion needed here would have significant impact on the processing times, the example and techniques are valid and effective , a good learning video and article

## Similar posts on daily.dev

- [Processing 11 million rows in minutes instead of hours](https://daily.dev/posts/processing-11-million-rows-in-minutes-instead-of-hours-jgagdggzi) · stitcher.io · 276 upvotes · 4 comments

---

Tags: [#performance](https://daily.dev/tags/performance), [#database](https://daily.dev/tags/database), [#architecture](https://daily.dev/tags/architecture), [#php](https://daily.dev/tags/php), [#mysql](https://daily.dev/tags/mysql)

[View this post on daily.dev](https://daily.dev/posts/once-again-processing-11-million-rows-now-in-seconds-oqf9cnfsn)