Running totals problem

  • kramaswamy (1/5/2010)


    Oh, neat. So I can do this instead:

    ...

    To have it use "url" as the root, instead of having no root. Nice!

    Yeap.

    It's the same like it is for any kind of craftsmanship : to have the right tools available and to know which one to use for the specific job 🙂

    Oh, and not to forget: to know where or who to ask for help if there's something suspicious ... 😉

    Final question from my side: what's the effect on duration after doing your latest fine tuning?



    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]

  • Honestly, it's hard to notice - the individual subsets are flying by so fast that there's not really a noticable change. Maybe it might have gone from like 5 seconds to 4 seconds, but its hard to say.

    Does make for cleaner code though, which is more than enough to sell me on the idea 😛

  • It seems like the time to find the root cause of poor performance and the "fix" was well spent!

    Glad I could help! 😀



    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]

Viewing 3 posts - 16 through 17 (of 17 total)

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