The slow performance of HubSpot "find associated objects" columns (also called "Retrieve associated objects" in Clay) is likely related to API rate limits.
When running HTTP API requests that hit rate limits, performance can significantly slow down, causing operations to queue for hours.
To improve performance, you can adjust the Request Limit and Duration settings in your HTTP API configuration. Set a Request Limit that specifies how many requests are allowed in a given timeframe, and a Duration that sets this timeframe (between 1-900,000 ms). For proper functioning, your rate limit should average at least 5 requests per second.
You might also want to check if you've configured optional parameters like "Limit" in your Retrieve associated objects settings, which could help manage the data volume being processed.