Too much memory usage issue

[gokhanabatay]

We are developing ***** system with nhibernate, our domain model has 900+ tables.
When we build session factory, sql command cache causes high memory usage issue.
Is there a way to tell NHibernate Lazy init all sql commands, when its needed?
Maybe memory cache can be used for unused sql command cleanup?

Below memory dump was taken after first request.

Duplicate queries

[gokhanabatay]

When using "default_batch_fetch_size" config its increases memory usage too much. Without "default_batch_fetch_size" results are acceptable.

[hazzik]

Yeah, we know. @gokhanabatay it was reported already.

Duplicate of #1316

Can you try "fix" in #1904?

[gokhanabatay]

Can you try "fix" in #1904?

"Agree. Better to optimize the code in batchers instead." you said in #1944
Lazy sql initialization is not implemented, only choice is to remove global default_batch_fetch_size hibernate config file?
So we remove default_batch_fetch_size in config and result are posted at previous message.
Only merged pull request is #1942 reflection performance fix with default configuration bytecode-provider=lcg(default) reflection-optimizer=true(default).

@hazzik which fix, I can try right now?

[EngSayed]

@hazzik, after adding "default_batch_fetch_size": 25 my application consumes double of the memory without using default batch size. I am not seeing a fix in #1904
Could you please let us know how to fix this while having batches?

[bahusoid]

See #2959

[EngSayed]

See #2959

Yes, I just found this one and about to test it but does it go with "default_batch_fetch_size" or only use "batch_fetch_style" ?
I am guessing both properties to set, right?

[fredericDelaporte]

They do not control the same thing. batch fetch size controls the batch size, and disable batching if it is 1 or less, whatever the value of the fetch style. So, you still need to specify batch sizes if you want to use batching.

The style only changes the implementation used for batching, when batching is enabled.