Add ability to change batch size for AppendCsv

SteveWinward / GoogleSheetsWrapper

Google Sheets API .NET Wrapper Library

MIT License

48 stars 13 forks source link

Closed drgrieve closed 2 months ago

drgrieve commented 2 months ago

Currently processing a 10K line CSV with default limit of 60 apis calls in a minute.

Batch size of 100 with 1 second delay was taking too long, so I needed to be able to change batch size.

In my test project I changed batch size to 500 and this has worked and takes time down enough, not tested larger batch sizes.

Ideallly there would be a config option, but I've just added a parameter to go along with batchWaitTime and have made minimal code changes.

SteveWinward commented 2 months ago

Thank you @drgrieve for your pull request! I’ll work to get this merged and a new version released to Nuget this week.

SteveWinward commented 2 months ago

@drgrieve look for the latest Nuget version 2.0.18 to get published which will include these changes!