CSV beats JSON on file size by 2.4x in 200,000-row benchmark test

·8 views

A developer benchmarked CSV and JSON formats using a 200,000-row, 12-column dataset on Node.js v22.18.0 to compare real-world performance. CSV produced a 20.5 MB file versus JSON's 49.3 MB, making CSV 2.4x smaller due to JSON's repeated key names and character escaping overhead. Conversion speeds were comparable, with CSV parsing at roughly 75,234 rows per second and JSON at around 70,908 rows per second. The size difference has direct implications for bandwidth and storage costs in log files and data export pipelines. Experts recommend JSON for APIs and nested data structures, while CSV remains the better choice for flat tables, spreadsheets, and analytics workflows.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Logic-based Sudoku solver cuts search nodes by 14,000x over basic backtracking

A developer benchmarked three Sudoku-solving strategies against the same engine and 40 identical puzzles to measure how much searching each approach requires. The naive backtracking method used in their shipped puzzle game averaged 28,835 search nodes per puzzle, while a most-constrained-variable (MRV) heuristic reduced that to 177. A logic-based constraint propagation solver went further, averaging just 2 nodes overall and only 3 even on Expert-difficulty puzzles. On Expert puzzles alone, the logic solver required roughly 34,000 times fewer search nodes than naive backtracking. The benchmark code is open source and fully deterministic, allowing anyone to reproduce the exact results by running a single command.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer Builds VS Code Tool to Map Live Call Chains After AI Agents Break Contracts

A developer frustrated by AI coding agents silently breaking system contracts built Contour, a VS Code extension that automatically maps real-time call chains across Java/Spring Boot backends and React frontends. The tool addresses a common problem where agents or humans edit one side of a codebase without knowing downstream dependencies exist, such as scheduled jobs, Kafka events, or chained service calls. Contour reads source code directly to reflect how a system actually connects at any given moment, rather than relying on outdated documentation or diagrams. It surfaces inline CodeLens annotations in the editor gutter, showing which frontend calls hit which controller endpoints and vice versa, with explicit warnings when no caller or handler is found. A companion tool called Contour MCP was also built to let AI agents query the call-chain map directly, rather than operating with only single-file context.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

How to Diagnose and Fix a Slow WooCommerce Checkout Page

WooCommerce checkout pages are excluded from page caching by design, making them uniquely vulnerable to performance issues that standard caching plugins cannot address. Tools like Query Monitor can identify the root cause by revealing total query counts, query times, and the specific plugins responsible for excessive database calls. Common culprits include shipping plugins making live carrier API calls on every update, unnecessary cart fragment requests, synchronous calls by analytics and marketing plugins, and bloated autoloaded data left behind by old plugins. Installing an object cache solution such as Redis or Memcached can significantly reduce repeated database hits on these dynamic pages. If application-level fixes fail to improve checkout speed, the bottleneck likely lies at the hosting level, including PHP version, worker count, or shared server resources.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

ESP32-HTTP-Client Library Cuts RAM Use 99% and Speeds Up API Calls 12x

A new open-source library called ESP32-HTTP-Client aims to solve common memory and performance problems faced by ESP32 developers working with REST APIs. Unlike the standard HTTPClient and ArduinoJson combination, which buffers entire HTTP responses in RAM before parsing, this library streams JSON data directly into C++ variables without intermediate memory allocation. The library also maintains persistent TCP/TLS connections via HTTP Keep-Alive, eliminating repeated handshake overhead on consecutive requests. Benchmark tests across 100 HTTP GET requests showed heap allocation dropping from roughly 58 KB to near zero per request, and average execution time falling from 750 ms to 59 ms. The library is available for both PlatformIO and Arduino IDE under the identifier ESP32-HTTP-Client by developer PedroFnseca.

0 comments Read more at DEV Community