Stored procedures or DLL

Results 1 to 2 of 2

Thread: Stored procedures or DLL

  1. #1
    Join Date
    Dec 1969

    Default Stored procedures or DLL

    Hello,<BR>Is it better (in terms of speed) to perform, say, inserts on a database in the function of a DLL or the SQL in a stored procedure? I know it&#039ll be easier to change the stored procedure than change the DLL and then have to stop IIS, restart it and recompile the DLL mind...<BR><BR>Hope you can help,<BR>Andrew

  2. #2
    Join Date
    Dec 1969

    Default RE: Stored procedures or DLL

    Stored Procedures have all sorts of advantages. The biggest being the fact that their execution plan is compiled and ready to roll which means they are faster than dynamic SQL statements (no matter where these statements are kept, DLL or ASP page).<BR><BR>Hope this helps,<BR>Thomas

Posting Permissions

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