Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Gaitano Boeraeve 17 posts 56 karma points
    Jul 19, 2012 @ 14:29
    Gaitano Boeraeve
    0

    Diving into the Umbraco database: Distinction in using SQL or Stored Procedure

    Right now I'm diving into the Umbraco database to get a better knowledge of where everything is stored.
    I'm using SQL Profiler to quickly see which tables are updated.

    After adding some nodes/types I notice Umbraco uses different ways to get sets from the database.
    Mostly the stored procedure sp_executesql is used, followed by an SQL Statement.
    But in other cases there is just an  regular SQL statement doing the call to the database.
    When a stored procedure is used, mostly there are a lot of parameters in the statement.

    So is my guessing right that the choise between SQL or Stored Procedure depends on the parameter count?
    I've read somewhere that this provides better performance?

Please Sign in or register to post replies

Write your reply to:

Draft