Post reply

Speeding up query in a VBScript file

  • November 6, 2007 at 7:36 am

    #748662

    Heh... you've basically pulled the wings off of any chance of performance by using outside code to do something inside the database... you said that you want to import 26MB and then do that post processing of using a cruise ship ID to insert into another table...

    If you think you simply must use SSIS for the import instead of using really high speed functionality like BULK INSERT, I supposed that's ok (not for me 😉 ) but using VBS to copy rows one at a time from one table to another is RBAR on steroids... why not write a nice little stored procedure to do it for you and call the sproc?

    By the way, I don't know what your data actually looks like, but if it's trully a flat file, BULK INSERT will import 26MB of data in the proverbial blink of an eye as will the query you need.

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

Viewing post 1 (of 2 total)

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