Post reply

sql server Raiserror function

  • February 11, 2005 at 2:28 am

    #65984

    Hi,

    Raiserror function is used to catch the exceptions,right.But is it a performance

    degrader on the database.

    can anyone clear my doubt.

    Thank U

  • February 14, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • February 14, 2005 at 2:21 pm

    #542153

    My guess would be that there would only be extra overhead when the RaiseError was invoked (Maybe not even then).

    You could test it by running a script without any RaiseError statements then adding the RaiseError statements and comparing the results.  If the timings are the same with no errors conditions, then you should be okay.

     

    Hope this helps

  • February 14, 2005 at 4:06 pm

    #542161

    If the RAISERROR Function is a performance degrader, then so is all types error trapping in your code! As Mark Manis has stated, try it and see for yourself and then come back to us with some concrete evidence!

    Kindest Regards,

  • February 15, 2005 at 9:13 am

    #542314

    One of the main uses of RAISERROR is to prevent client side code from creating EMPTY ADO recordsets which become really expensive objects in the middle tier of a heavily used DB. It also allows to create a message layer that can be more friendly to the front end in comparison to the default

    hth

     


    * Noel

Viewing 5 posts - 1 through 4 (of 4 total)

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