I suggest you ...

Allow us to ignore "select N+1" and "select N+1 across multiple sessions" alerts separately.

When integrating NHProf with a continuous integration environment and/or using NHProf to profile integration tests, "select N+1 across multiple sessions" alerts are often false positives. We should be able to ignore them separately.

3 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Adam Essenmacher shared this idea  ·   ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Carel commented  · 

        still there in 2184, example statement of which I submit a couple (paging over some table) and some give this alert while others don't:

        SELECT TOP (30 /* @p0 */) InternalId5_0_,
        Version5_0_,
        iso3_5_0_,
        name5_0_,
        symbol5_0_,
        enabled5_0_,
        number5_0_
        FROM (SELECT this_.InternalId as InternalId5_0_,
        this_.Version as Version5_0_,
        this_.iso_code as iso3_5_0_,
        this_.name as name5_0_,
        this_.symbol as symbol5_0_,
        this_.enabled as enabled5_0_,
        this_.number as number5_0_,
        ROW_NUMBER() OVER(ORDER BY CURRENT_TIMESTAMP) as __hibernate_sort_row
        FROM MXCurrencies this_) as query
        WHERE query.__hibernate_sort_row > 60 /* @p1 */
        ORDER BY query.__hibernate_sort_row

      • Carel commented  · 

        I second that, regards

      Feedback and Knowledge Base