bharat sethi (12/18/2013)
Hi! The data is not going to a web page. It's a SSIS package which process this task and then provide this data to sucessor tasks or other processes. there is no image/text columns (pl. refer previous replies for columns list) and H/w had a gigbit LAN only.
The query is Select <column names> from <Temp.TableName>.
ok, nine posts into this thread, and now you tell us this is part of an SSIS package? don't you think you might have been relevant to the question at hand? the first post implies it's slow, but without identifying much more than that.
if it's in an SSIS package, why does it have to be fast? doesn't the data simply need to be processed, regardless of whether it takes one second or one minute?
help us help you.
remember, we are not standing in your cubicle, looking over your shoulder; we only know what you post here. A lot of us have an incredible amount of experience, and volunteer our time to help others.
if you can provide details, we can probably help, but so far, you haven't done your part on providing anything other than a textual description of the issue.
so far, I've understood that you are returning 200K rows of data, and it's a pretty large dataset, and it takes "more than 3 Minutes to list all records."
how is it you see it takes 3 minutes to "list" them?
in ssms by running the stored procedure call?
for any of us to diagnose anything, we need concrete things like a description of the process, and what is actually going wrong; any specific error numbers raised; stored procedure definitions, table definitions, indexes on the relevant tables, actual execution plans; anything that might identify to us the pain points you might be experiencing.
the proc definition might be relevant for example, if you were using a linked server, or any of a number of other things i can think of performance wise.
Hope you can help us help you!
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!