Discussion:
[nhusers] SELECT N+1 problem and BatchSize
Rainer Huber
2017-06-29 19:30:31 UTC
Permalink
Hi,

I'm using NHibernate 4.0 with mapping by code. I know that I can set the
batch-size of bags/collection within the mapping-file
to avoid N+1 problem. *BUT *is it possible to set the batch-size of defined
bags/collections per session or even better per transaction? We have
many situation in which the batching would make our application slower as
not needed data is loaded. In other situations
it would speed things extremly up.

*Fetch() is not an option in this special cases.*

Thanks
--
You received this message because you are subscribed to the Google Groups "nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nhusers+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.
Loading...