roo-rb/roo

Google sheets export low performance

chalmagean opened this issue · 0 comments

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