SQL Server Performance

SP call by program running slower compared to dire

Discussion in 'General Developer Questions' started by vladimir_sim, Apr 2, 2007.

  1. vladimir_sim New Member

    Hi,

    Our program use to calling maybe 10+ SP to insert/update/delete
    data. All the call to SP seem to be slow.

    However, when we change all the call of SP (concatenate all the SP together)into direct calling
    by the program, the speed is impressive.

    For example,

    a)Overall speed is very slow
    Program call - SP1 (delete)
    call - SP2 (insert
    call - SP3 (update)


    b)Overall Speed is very fast, similar to above method
    If we concatenate all the 03 SP code into
    direct call by the program, instead of calling individual
    SP,the speed is impressive.

    Hence, is there any way to achieve the same speed using SP ?

    Thank you
  2. Adriaan New Member

    You can have as many inserts/updates/deletes in a single procedure as you need. T-SQL is a procedural language, so you're not limited to one "query" per procedure.
  3. satya Moderator

Share This Page