roo-rb / roo

Roo provides an interface to spreadsheets of several sorts.
MIT License
2.78k stars 503 forks source link

Google sheets export low performance #516

Open chalmagean opened 4 years ago

chalmagean commented 4 years ago

I have a file exported from Google sheets, and the same data copied into excel (values only) and saved from Excel.

I've benchmarked the two files, and here are the results.

Excel 0.002513 0.001626 0.004139 ( 0.004606) Google: 0.077944 0.063764 0.141708 ( 0.143287)

The file size difference is significant between the two. The google export is 2.3mb and the Excel one is 28kb, so that could explain things.

System configuration

Roo version: 2.8.2 Ruby version: 2.5.1