April 20, 2009 at 2:12 am
when i run a select query with 7 joins on database it is giving the same set of results but consuming different amount of time once the query will run for 1 min next for 30 sec next for 11 sec i am executing the query continuesly
not having much time log
i have executed the query atlease for 10 times and got 7 different timings
coould some one help me out
April 20, 2009 at 3:14 am
On SQL Server there are many activities concurrently run and the execution time for any SQL depends upon the Load at that time on your server this may be only reason, u are getting varying execution time.
April 20, 2009 at 3:19 am
Is there any blocking?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2009 at 4:30 am
there were no blocking
ours is 4 GB ram and the size of the records it returns is 2,50,000 and which is only 660MB
April 20, 2009 at 4:44 am
660 MB of data's a fair bit. I wouldn't be surprised if the time difference is due to the network. That's a lot of data to be streaming out.
What's the application going to do with a quarter of a million rows? No one's going to read all of that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply