Home Forums SQL Server 7,2000 Performance Tuning OPENROWSET select statement performance -- runs in 4 seconds on test server vs. 3 minutes on production server. RE: OPENROWSET select statement performance -- runs in 4 seconds on test server vs. 3 minutes on production server.

  • September 8, 2008 at 7:11 pm

    #868811

    rg (9/8/2008)

    Just wanted to follow-up to above: Currently suspecting network latency, as SQL test and Oracle prod servers are located in West Coast data center, whereas SQL prod server is located in East Coast data center,...

    Heh... yeah, that might do it. We had a million row job that took 10 minutes to run locally... took almost 3 hours remotely. The fix was to do the job locally and only transfer the answer remotely. Even that still took a bit of time.

    --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)