mibuso.com
Home› SQL Performance
Options

What is Smart SQL and does anyone have any documentation?

jackharrisjackharris Member Posts: 5
in SQL Performance
I see that there's an option to disable it, but I wanted more info on what it was and whether there was any documentation that I could review with my team as to whether we should enable it for our clients?

Answers

  • Options
    bbrownbbrown Member Posts: 3,268
    "Smart SQL" is what allows NAV\BC to retrieve data from multiple related tables by sending a single complex SQL query. Think joins. It should always be enabled (default setting) except when investigating the performance of said queries.

    When it is disabled, the data for each table is retrieved separately. As in the way old NAV worked.

    There are no bugs - only undocumented features.
  • Options
    cgimeccgimec Member Posts: 3
    Smart SQL should always be enabled unless you want to debug and you don't want to spend time braking down the queries.
    Disabling it might help you find the slow queries a bit quicker. It works beautifully with Extended Events and it helps a lot knowing which process is slow so you can replicate and trace.
Sign In or Register to comment.