Velocity Reviews - Computer Hardware Reviews

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

Thread Tools

Re: SQL Query is taking too much time

Gregory A. Beamer
Posts: n/a
"ashu2409 via" <u54936@uwe> wrote in

> i want to make it 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

Twitter: @gbworld

| Think outside the box! |
Reply With Quote

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