.png&w=3840&q=75){kind=logo}
Investigating Slow Performance in Table Record Lookup
Hey team - my look up other record in table is super slow (says queued, but no results)
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Tanvi R.··Hi Harvey thanks for reaching out. Your lookup record enrichments are not running correctly because the input values for the company table ID and company record ID are not properly linked. https://downloads.intercomcdn.com/i/o/1171459719/43d707a8fead8764026b1e36/CleanShot+2024-09-06+at+14_00_07%402x.png?expires=1725648300&signature=129bce53aac6fda0c5a51b71abcb836dff270e217136a57e4053161da7cf45f5&req=dSEgF817lIZeUPMW1HO4zRRsJLooF6BnZ3nC2Q396o824SEj5WJqQmISy9ii%0ASt27%0A The columns you referenced in the company enrichment are empty which is why you are seeing an error message for "missing input field." https://downloads.intercomcdn.com/i/o/1171466176/94f28661b743b491496273bd/CleanShot+2024-09-06+at+14_05_18%402x.png?expires=1725648300&signature=e784bdcf6d98a1da326634efc50c2e97241fcc1c27060fa61559704dcf578de4&req=dSEgF814m4BYX%2FMW1HO4zfIOaFnunZL7ziruxiYQdSSLYyDCVIrk3VkBWGv7%0ANPqp%0A Which lookup enrichment are you using? If it's the Lookup Single/Multiple rows enrichment, you should be able to select the table you want to lookup from in a drop-down menu. https://downloads.intercomcdn.com/i/o/1171468260/ccf9c6f753624743e12509c8/CleanShot+2024-09-06+at+14_13_50%402x.png?expires=1725648300&signature=bbf09d14a23c324086cb4d96039bf1ed5b3c865f2969532fedce718df4cb5187&req=dSEgF814lYNZWfMW1HO4za5LcJQbF5U9qVMrXFuMRUvGRfSGGcAUMSeuklUo%0AHClI%0A
lol... i might be spaming it too much that's why? same thing is happening to find companies:
Hey there Harvey thanks for reaching out, managed to get the first lookup column running in your table, it looks like your table is facing high latency from having all of these lookups run simultaneously.
i thought so... thanks man
LuisArturo anyway i can do this faster? Maybe uploading to a googlesheet?
Bo (.··Hey Harvey, adding to this; thanks for the video you sent btw! 😊 Yes, as seen in the video, things can slow down when you’re handling a large number of columns, rows, and multiple enrichments at once. This takes up a lot of processing power, which can naturally cause delays. Even if you try a different method, if there are high row counts and numerous enrichments, the slowness is likely to persist. The best way to improve speed is to streamline your queries, work with smaller batches, and reduce the processing load. We’re constantly monitoring this to enhance performance, so your feedback is really helpful! Let me know if you need any further assistance! 😊
hmm cause i want to exclude tables from my company search, but you can only exclude one table from the company search, and the rows are limited at 50k
cause i want to get net new company
- Bo (.··
Got it! Since you’re on the enterprise plan, we can raise the limits if that’s something your team is interested in. I’m happy to message the GTM team if needed. There might be some extra costs and so and so but would need to have them confirm. Also Just note that the exclude function has a 65k company limit, which might still cause some slowness. Others handle large datasets by using database providers with API access, for example: 1. Adding tables within a table. 2. Setting up an HTTP API call to a provider like Supabase. 3. Returning whether there are results. This approach could speed things up! Let me know if you’d like more details or help contacting your team! 😊
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Hey team -- after a few days, my look up is still super slow
- Bo (.··
Hey Harvey, We’ve increased the workspace rate limits for actions, but given the volume of lookups you’re running, the current pace is still expected. It should be slightly faster, but since all the lookups are going towards your workspace rate limit, it will take some time, especially if you’re running multiple workspaces (e.g., 10 workspaces at once). Each of those contributes to the overall rate limit, which is why it may feel like it’s moving slowly. Let me know if you need more help! 😊