Hacker News new | ask | show | jobs
by hyperbolablabla 1120 days ago
Why is there a hard row limit at all? For a sufficiently large worksheet could you not page data in/out from disk?
1 comments

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.