News for hackers. Stuff that matters.
Re:Show HN: GS-Calc – a spreadsheet with 12M rows by hyperbolablabla on Tuesday May 23, 2023 @11:00AM (#36045279)
Why is there a hard row limit at all? For a sufficiently large worksheet could you not page data in/out from disk?
Re:Show HN: GS-Calc – a spreadsheet with 12M rows by jpiech on Tuesday May 23, 2023 @11:48AM (#36046072)
Unfortunately, even for fast NVMe SSDs random access to cells (which determines the performance) can't compare to RAM. In the example above these 0.5 billion cells can still be fully loaded to 16GB RAM, but adding further such worksheets will cause spooling and noticeable slow down.