The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.
It depends on the script - without seeing the details there’s no way to know what approach might be better or what design pattern to avoid. It’s been my experience that processing 8,000 items are relatively easy for Airtable scripts to handle so something complex must be happening for each item.
@kuovonne is an expert when it comes to optimizing Airtable script for performance.