Re: Stored procedure overhead

Another possibility is the fact that you must run UPDATE STATISTICS on tables that the stored procedure will use before you create the procedure itself. Partha Dutta pdutta@airmail.net toby denbow <tdenbow@mathworks.com> wrote in article <32C9B17D.762@mathworks.com>... > Paul, > You may want to check to see if any of the talbes you are updating have > a trigger on them. The SPL you are running will not complete untill all > triggers have been executed. Also, if you are doing an update to a > large table, or doing a lot of inserts, the SPL could be slowed down > while committing the work. (SPL's automatically execute within a > transaction I think.) > > Other than that I do not have any other suggestions, > -Toby Denbow