Feedback:

← General

Compiled sql script triggers and procs

Compiled (as opposed to interpreted) scripts for better performance.

26 votes
Vote 0 votes Vote Vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Forgot password?
    Create a password
    I agree to the terms of service

    You'll receive a confirmation email with a link to create a password (optional).

    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    jeremym1234jeremym1234 shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  jeremym1234jeremym1234 responded  · 

    We did not end up precompiling the scripts, but we did implement a variety of changes that have significantly improved stored procedure performance (in par with our UDFs, which have always been much faster). Planned to be part of the v10 release the first half of 2010.

    Show previous admin responses (1)

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Forgot password?
      Create a password
      I agree to the terms of service

      You'll receive a confirmation email with a link to create a password (optional).

      Signed in as (Sign out)
      Close
      Close
      Submitting...
      • jeremym1234jeremym1234 commented  ·   ·  Flag as inappropriate

        We are leaving them as interpreted for now, but have identified many performance enhancements for the next release. As such, I'm going to mark this one as planned and then completed once the proc/trigger performance enhancements are finished.

      General

      Knowledge Base and Helpdesk

      (thinking…)
      Reset