All,
I have a SQL query that performs an insert; we're talking about 20 columns X 150,000 - 250,000 rows depending on the month. Normally from SQL Query Analyzer this query, actually I execute it via a stored proc, will take anywhere from 8 - 12 seconds to finish. Unfortunately this query is one step in a chain and in an effort to break away from MS Access (where this process was kept before) I threw the whole thing into a DTS. But the same 8 - 12 second query run from SQL QA, takes a good 3 - 4 minutes when run from DTS. Can anyone tell me why?
Journeyman -- The Order of the Seekers of Truth and Penitence
I have a SQL query that performs an insert; we're talking about 20 columns X 150,000 - 250,000 rows depending on the month. Normally from SQL Query Analyzer this query, actually I execute it via a stored proc, will take anywhere from 8 - 12 seconds to finish. Unfortunately this query is one step in a chain and in an effort to break away from MS Access (where this process was kept before) I threw the whole thing into a DTS. But the same 8 - 12 second query run from SQL QA, takes a good 3 - 4 minutes when run from DTS. Can anyone tell me why?
Journeyman -- The Order of the Seekers of Truth and Penitence