NHibernate HiLo ID generator is performing a round-trip to the database per-row inserted

Question

When I configure my application to use HiLo Id generation, I see one round-trip per row inserted in the database. All the documentation I've read has indicated that I should see far fewer round-trips.

My objects are all generally configured (fluently) as such:

Id(t=>t.Id).GeneratedBy.HiLo("MyObject_Identity","MaxId","1000");

Additionally my batch size is set to 75 on the connection.

I know I'm probably doing something relatively stupid.

Answer 1

Do you mean you are seeing a round trip for each insert to go get a new high value for the ID? If so are you using a new instance of the SessionFactory on each operation? The SessionFactory is responsible for managing the retrieval of the high value. Typically you should only have one SessionFactory per application instance (via singleton or IoC container).