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

• For 20 million sample formulas with cells filled from B2 to the right and downwards 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 the last bottom-right cell:

  U1000001 =U1000000+V1000000+W1000000+X1000000

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

• Loading a 4GB+ workbook with over 500 million cells with 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 HDD (retaining all the data in RAM).

Back