JavaScript Pivot Table Processes 10 Million Rows in Browser Using Columnar Data

Developer Kasmav built AeroPivot, a framework-agnostic pivot table web component, and benchmarked it against a 2.8 GB CSV file containing 10 million rows and 33 fields. The project addresses a real-world challenge in embedded analytics: handling large datasets directly in the browser without server-side processing. A key architectural decision was using columnar data ingestion instead of traditional row-object arrays, which reduces memory overhead from repeated object keys, property lookups, and garbage collection pressure. Typed arrays such as Float64Array are used for numeric measures, making the data structure more efficient for aggregation operations. The benchmark recorded an initial CSV ingestion time of around 2 minutes on a Windows machine, with the post emphasizing that ingestion and pivot recalculation timings should be measured separately for accurate performance evaluation.