Post reply

report optimization

  • December 31, 2010 at 9:01 am

    #1268135

    Please save the execution plan as .sqlpaln file and attach it.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • December 31, 2010 at 9:30 am

    #1268140

    And please also post the query.

    Please understand we're not asking for this information to make your life difficult. We're asking because it's very hard to give useful advice around performance issues without having all the information.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 31, 2010 at 9:58 am

    #1268145

    i cant make any attachments .....the comp wont allow me , i actually checked the query in the MSSMS it fast ... it hardly takes like a second to exec , i think the report has got something to do with performance , i know that there is some aggregate functions being used in the report,

    what if i create a new DSV and do those aggregations in there and use the DSV with the report ,

    do you think it should help solving the issue ?

    thanks

    regards

    greg

  • December 31, 2010 at 9:59 am

    #1268146

    select accountbranchnumber,accountnumber,accounttype,currentbalance,

    postdatedimkey,monthname,condensecodedesc,statementdesc,branchname,accounttypedesc,groupname,

    division from MM_EOMRetail

    where

    accountbranchnumber = 230 and accounttype = 'd'

    order by division, groupname,accountbranchnumber,postdatedimkey

    thanks

    regards

    greg

  • December 31, 2010 at 10:09 am

    #1268152

    I recommend doing the aggregation in the query, if possible. I'm sure some of the problem is the aggregation.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply