• Opening a file over 0.5GB in size, with 20 columns and around 3.5 million rows, can take several seconds on a low-end PC.
  A worksheet with 20 million cells containing random floating-point numbers will open (more or less) instantly.
• Filtering around 3.5 million records/rows using the Filter() function/formula with, e.g., a RegEx expression takes about 2-3s (the time will grow as more filters are added, or as the number of columns increases).
• GS-Calc with a line (non-XY) chart containing a million random data points in a worksheet like the one shown below uses (according to Task Manager) about 27MB of RAM.
  Sample chart
• GS-Calc with an open workbook containing 200 new worksheets uses around 70MB of RAM.

• For 20 million sample formulas, with cells filled from B2 rightward and downward so that:

  B2: =b1+c1+d1+e1, C2: =C1+D1+E1+F1, D2: =D1+E1+F1+G1

  B3: =B2+C2+D2+E2, C3: =C2+D2+E2+F2, D3: =D2+E2+F2+G2

  and down to the last, bottom-right cell:

  U1000001 =U1000000+V1000000+W1000000+X1000000

  GS-Calc saves this as an 8KB file (since it detects patterns in cells to compress the data). Saving and loading takes about 5s on a low-end office PC.

• Loading a 4GB+ workbook with over 500 million cells of random floating-point numbers and text strings - 8 worksheets, ~12 million rows each - can take around 30s on a low-end office computer with 16GB RAM and an HDD (retaining all the data in RAM).

Back