batch-size guides, questions and discussions

Article0 replies4,393 followingPosted 03 Aug 2025, 00:30 UTC128.8K views2,550 votes

Diagnosing and Fixing NHibernate N+1 Select Problems in Lazy-Loaded Collections

Learn how to spot the NHibernate N+1 select problem in lazy‑loaded collections, diagnose it with SQL logging and session statistics, and apply batch‑size or fetch fixes.

Community & Careers · Guide

n1 lazy-loading batch-size

Community & Careers

Question1 answer1 comment1,923 followingPosted 12 Jan 2025, 03:49 UTC61.5K views3,245 votes

owner answered

could not initialize proxy - no Session when accessing lazy-loaded collection

The goal is to lower CPU and memory consumption for a low‑traffic NHibernate‑based web or service application while preventing LazyInitializationException when lazy‑loaded collections are accessed after the session is closed. Constraints include choosing appropriate second‑level cache regions and expiration policies, setting an AdoBatchSize that balances bat

Community & Careers · Editorial question

batch-size

nhibernate performance

Community & Careers

Question1 answer4,475 followingPosted 30 May 2024, 05:36 UTC122.5K views3,686 votes

owner answered

NHibernate N+1 selects on lazy collections: batch-size in mappings or query-level Fetch for diagnosis and fix

Symptom A screen that loads a list of parent entities and touches a lazy child collection per row issues one SQL statement for the parents plus one per parent row, visible in NHibernate.SQL output as repeated near-identical selects. The goal is to confirm the bottleneck is query count rather than query cost, and then pick a fix. Constraints and uncertainty N

Community & Careers · Editorial question

fetching-strategy n-plus-1 batch-size

Community & Careers

Question1 answer4,343 followingPosted 10 Sept 2022, 07:17 UTC87K views848 votes

owner answered

SpriteBatch batch size limit and flush frequency across DirectX and OpenGL backends

Goal: Find a SpriteBatch batch size that reduces the number of End‑induced flushes per frame while staying within the GPU’s vertex‑buffer capacity on Windows DirectX, Linux/macOS OpenGL, and any other supported MonoGame backend. Constraints: The developer must query GraphicsDeviceCapabilities.MaxVertexCount to avoid exceeding hardware limits, and must consid

Community & Careers · Editorial question

rendering-performance

monogame batch-size

#batch-size

Diagnosing and Fixing NHibernate N+1 Select Problems in Lazy-Loaded Collections

could not initialize proxy - no Session when accessing lazy-loaded collection

NHibernate N+1 selects on lazy collections: batch-size in mappings or query-level Fetch for diagnosis and fix

SpriteBatch batch size limit and flush frequency across DirectX and OpenGL backends

#batch-size

Diagnosing and Fixing NHibernate N+1 Select Problems in Lazy-Loaded Collections

could not initialize proxy - no Session when accessing lazy-loaded collection

NHibernate N+1 selects on lazy collections: batch-size in mappings or query-level Fetch for diagnosis and fix

SpriteBatch batch size limit and flush frequency across DirectX and OpenGL backends