input tools to use - static input or indb input?

[becki]

if i'm downloading from an sql database and of course, it's a huge file.  is it faster to use a static input tool or is it faster to use indb input?  right now, i have an sql line of "SELECT * FROM "MSS"."GIA_STG"."URB_SCI_JUMBO_VERTICAL" where TYPE='PM'" to limit my import to just one value of one field.  thanks

becki kain

[rohanonline · Accepted solution]

Generally speaking, if you need only partial dataset, then IN-DB tools work better. However, if your criteria will still download 40-50% of the DB, then it's not worth using the IN-DB tools. Hope it helps.