--- title: Wow that is impressive. 1.7M events processed per second... description: A PHP developer optimizes a script processing 11 million database events, improving performance from 50k to 1.7M events per second through incremental changes.... canonical: https://daily.dev/posts/wow-that-is-impressive-1-7m-events-processed-per-second-is-huge--dyxc4ykin twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Wow that is impressive. 1.7M events processed per second is huge. | daily.dev og:description: A PHP developer optimizes a script processing 11 million database events, improving performance from 50k to 1.7M events per second through incremental changes.... og:url: https://daily.dev/posts/wow-that-is-impressive-1-7m-events-processed-per-second-is-huge--dyxc4ykin og:image: https://api.daily.dev/og/posts/DyxC4yKIN.png og:image:alt: Wow that is impressive. 1.7M events processed per second is huge. og:image:width: 1200 og:image:height: 630 og:locale: 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. # Wow that is impressive. 1.7M events processed per second is huge. **[Daniel, Petrica Andrei-Daniel](https://daily.dev/sources/owrllg9wnblfz85umokdx)** · [@danielpetrica](https://daily.dev/danielpetrica) · 0 upvotes · 0 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: ## 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 · 277 upvotes · 5 comments - [What Replo learned optimizing 100\+ billion events in ClickHouse](https://daily.dev/posts/what-replo-learned-optimizing-100-billion-events-in-clickhouse-moguewyij) · ClickHouse · 2 upvotes · 0 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/wow-that-is-impressive-1-7m-events-processed-per-second-is-huge--dyxc4ykin) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"DiscussionForumPosting","mainEntityOfPage":"https://daily.dev/posts/wow-that-is-impressive-1-7m-events-processed-per-second-is-huge--dyxc4ykin","headline":"Wow that is impressive. 1.7M events processed per second is huge.","text":"Shared: Once again processing 11 million rows, now in seconds","url":"https://daily.dev/posts/wow-that-is-impressive-1-7m-events-processed-per-second-is-huge--dyxc4ykin","datePublished":"2026-01-29T16:34:06.980Z","dateModified":"2026-01-29T16:34:06.989Z","author":{"@type":"Person","name":"Daniel, Petrica Andrei-Daniel","url":"https://daily.dev/danielpetrica","image":"https://avatars.githubusercontent.com/u/4850686?v=4","description":"Featured Laravel Artisan, DevOps & New Relic Consultant | Building Scalable Systems with Precision \n","interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"EndorseAction"},"userInteractionCount":2020}},"image":"https://media.daily.dev/image/upload/s--1KxV4ohY--/f_auto/v1722860400/public/Placeholder%2007","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"sharedContent":{"@type":"WebPage","url":"https://api.daily.dev/r/oqF9cnFsn"},"isPartOf":{"@type":"WebPage","url":"https://daily.dev/sources/owrllg9wnblfz85umokdx","name":"Daniel, Petrica Andrei-Daniel"}} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Daniel, Petrica Andrei-Daniel","item":"https://daily.dev/sources/owrllg9wnblfz85umokdx"},{"@type":"ListItem","position":3,"name":"Wow that is impressive. 1.7M events processed per second is huge."}]} ```