Re: SQL Query is taking too much time

Discussion in 'ASP .Net' started by Gregory A. Beamer, Oct 15, 2009.

  1. "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! |
    *******************************************
    Gregory A. Beamer, Oct 15, 2009
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. RSoIsCaIrLiIoA
    Replies:
    8
    Views:
    273
    Mark McIntyre
    Dec 21, 2005
  2. cpp4ever
    Replies:
    3
    Views:
    363
    Francesco
    Sep 8, 2009
  3. Phonethics Mobile Media

    urllib2.urlopen taking way too much time

    Phonethics Mobile Media, Apr 19, 2010, in forum: Python
    Replies:
    0
    Views:
    453
    Phonethics Mobile Media
    Apr 19, 2010
  4. Shailendra

    Multiprocessing taking too much time

    Shailendra, Jul 29, 2010, in forum: Python
    Replies:
    1
    Views:
    270
    John Nagle
    Jul 29, 2010
  5. Dysgraphic Programmer

    cProfile taking up too much memory?

    Dysgraphic Programmer, Mar 14, 2011, in forum: Python
    Replies:
    0
    Views:
    211
    Dysgraphic Programmer
    Mar 14, 2011
Loading...

Share This Page