Post reply

Question on Stored Proc

  • April 14, 2006 at 12:51 pm

    #113680

    Hi Everyone,

    I have written a stored procedure, which actually

       1. selects data from database1

       2. inserts data to database2

       3. inserts error information on database3.

    What is the right place to deploy my stored procedure, I mean which place the stored procedure got to be executed so that it gets the maximum performance.

    Thanks,

    Ganesh

     

     

  • April 14, 2006 at 1:21 pm

    #632677

    Well if your 3 databases are on one server I am not sure that it makes a difference.

    My personal preference from the information given would be to place the proc in database 2 because it is the database where the principal data change activity is taking place.

    LinkedIn Profile

Viewing 2 posts - 1 through 2 (of 2 total)

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