Investigating Slow Performance in Table Record Lookup

https://app.clay.com/workspaces/16336/tables/t_TCgxywbTbXN5/views/gv_dfz6eiwsxyBi

👋 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!

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

Tanvi (Clay) https://www.loom.com/share/60cf6448fd7b4be58d3a647382dc9ba2

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 (Clay) anyway i can do this faster? Maybe uploading to a googlesheet?

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

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.