stored procedure performance

Results 1 to 2 of 2

Thread: stored procedure performance

  1. #1
    kevin Guest

    Default stored procedure performance

    hello,<BR><BR>In the page I am writing I have 2 options:<BR>Write clean code that uses 3 different stored procedures or<BR>Write hard to follow code that uses just one stored procedure.<BR><BR>I was wondering if somebody has any idea of what the performance hit of calling 3 stored procedures versus one is. I have tried profiling the code and I get minimun difference in Miliseconds.<BR><BR>Does the performance get worse as there is heavier load on the service and everybody is calling 3x more stored procedures on the site?<BR><BR>thanks <BR>kev

  2. #2
    Owen ( Guest

    Default RE: stored procedure performance

    I would stick to 3 seperate procedures. Remember that caching will kick in, and having 3 seperate procedure won&#039t really be a performance drain.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts