voltrondata-labs / arrowbench

R package for benchmarking
Other
13 stars 9 forks source link

Add a benchmark for large file scans versus smaller files #41

Open jonkeane opened 2 years ago

jonkeane commented 2 years ago

When scanning and doing operations on files, it would be nice to know if it's more efficient to have one large parquet (for example) file per partition, or to have more smaller files.

lidavidm commented 2 years ago

This would be good to have. For Parquet specifically, looking at row group sizes may also be interesting - we can potentially get more parallelism with smaller row groups, but if you're reading only a few sparse columns of many, and you're on something like S3, small row groups also mean you have to make lots of small reads which is not an ideal I/O pattern.