Run Time taking really long when connecting to large table via SQL Server

[Joshua_Bova]

I am trying to connect to a SQL Server database table that has approx 1 mil rows and 48 columns. It takes more than 4 minutes to populate. Is there something I need to do to enhance the run time? Even when I add a SELECT tool and only select the columns I NEED (reducing from 48 to 12) it still takes 4 plus minutes.

[MarqueeCrew · Accepted solution]

@Joshua_Bova,

If you are reading the data into an input tool and then selecting the desired fields using a SELECT, then you are still reading and passing the data over the network.  I would change the select * from tablename in the SQL to the exact field list desired.  You can achieve this either with SQL statements (e.g.  Select Field1, Field2, FieldN from tablename) or via the table view.  This should improve the READ performance.

Cheers,

Mark

[Joshua_Bova]

Mark,

Selecting only fields needed directly in the query from the input tool made this workflow run much faster. Thank you!

Josh