Software

Ask something
Question Locked

MS SQL 2005 Sever performance

0 helpful
2 replies

by cmmurugan

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Dear Sir,
Warm Greetings

One Stored procedure output started within 2 to 3 seconds and continued upto 20 seconds. If we redirect the output to a temporary table, its getting completed by 4 to 5 seconds. Anyhow if put select * from the temporary table it is taking more thann 20 seconds. Can you give some idea, whehere is the bottle neck of the issues?

Thanking you.
Regards
C.Manoharamurugan

2 replies

by shellbot

Don't use Select *
By doing that you are saying give me everything. Depending on how much data you have to trawl through that will slow things up a lot.

Try being more specific in what you want in your query.

How many rows were being returned from the select?

This discussion is closed to new replies.