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.
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_,
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
I second that, regards