Post reply

Balancing Writes

  • September 2, 2018 at 3:07 pm

    #2004230

    coolchaitu - Sunday, September 2, 2018 8:02 AM

    Thanks Jeff. Happy long weekend

    Thank you.  It just needs to get started.  The boss hit me with a suggestion about a particularly nasty problem we've been having with some turd party software.  He was headed down the right track but didn't realize the bridge was out so I spent yesterday solving the problem and testing the heck out of it.  I got done with the obligatory write-up as to what I thought should be done and how the turd party vendor could fix their junk both in the short term and in the long term.

    As a bit of a sidebar but right inline with what I've been talking about, the code I wrote runs 960 times faster than the original code, requires only one run per document, and replaces application code that would call on the data 14 MILLION times per hour.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • September 5, 2018 at 2:02 pm

    #2004595

    Jeff Moden - Sunday, September 2, 2018 3:07 PM

    coolchaitu - Sunday, September 2, 2018 8:02 AM

    Thanks Jeff. Happy long weekend

    Thank you.  It just needs to get started.  The boss hit me with a suggestion about a particularly nasty problem we've been having with some turd party software.  He was headed down the right track but didn't realize the bridge was out so I spent yesterday solving the problem and testing the heck out of it.  I got done with the obligatory write-up as to what I thought should be done and how the turd party vendor could fix their junk both in the short term and in the long term.

    As a bit of a sidebar but right inline with what I've been talking about, the code I wrote runs 960 times faster than the original code, requires only one run per document, and replaces application code that would call on the data 14 MILLION times per hour.

    ***Please note the message of NON support for this product***
     I believe what you are looking for is a federation of SQL Servers.
    https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms190381(v=sql.105)

Viewing 2 posts - 16 through 16 (of 16 total)

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