Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Re: SQL Query is taking too much time

Reply
Thread Tools

Re: SQL Query is taking too much time

 
 
Gregory A. Beamer
Guest
Posts: n/a
 
      10-15-2009
"ashu2409 via DotNetMonster.com" <u54936@uwe> wrote in
news:9da0957a8f60a@uwe:

> i want to make it fast.how can i do that.


If all 6 queries on the page use this many joins, you are probably
experiencing the majority of your problem on SQL Server.

Check the query plans in SQL Server and see if you are in need of
further indexing. If not, you may have to denormalize this a bit.

Peace and Grace,

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
cProfile taking up too much memory? Dysgraphic Programmer Python 0 03-14-2011 04:53 PM
Too Much Talent + Too Much Demand = ? Lawrence D'Oliveiro NZ Computing 5 02-18-2011 10:14 PM
Multiprocessing taking too much time Shailendra Python 1 07-29-2010 07:04 PM
urllib2.urlopen taking way too much time Phonethics Mobile Media Python 0 04-19-2010 12:44 PM
Too much delay in taking pictures Fantasia Digital Photography 11 11-05-2003 10:20 PM



Advertisments