Filtering with list before the Input Data Tool

Question

Hello folks,

I have a spreadsheet of 5000 records and then need to join to a 30m+ records Database.  I filtered as much as I could before it exits that input tool.  The spreadsheet takes 2 seconds to run.  However, the data needed from the Database takes 20 minutes.  Isn't there a way to use the 5000 records as a Pre-sql statement so I don't have to wait this long?  Been looking at Macros and pre-sql statements.  If not what am I missing?  I have a ton of these scenarios.  But, nothing is coming together for me.  Does anyone have some simple examples I can download?

Thanks in advance.

Kristin

CharlieS · Accepted Answer

So here's a couple rough tool layouts to give you some ideas on tools to use here (both In-DB and not). The tools at the end will error since I don't know the field names or have the DB connections.

Kristin · Accepted Answer

Yep I built this as I was waiting for your answer.   I used the join and it's 6 minutes.  WAY better than before.  Thanks!!!