Hi,

I'm in a C#-project which uses NHibernate (4.0) with Envers (2.0) and 
Fluent.
The problem I'm facing is that executing an Audit-Query generates 
subsequent queries for the revision info. 
Example:

    var query = AuditReader.CreateQuery()
       .ForEntitiesAtRevision<Entities.Attribute>(someNumber)
       .Add(AuditEntity.Property("ParentObject.Id").Eq(someId))
       .Results();

If this query returns, for example, 100 entities having different revision 
numbers, Envers generates 100 queries in separate roundtrips to read the 
revisioninfo entity.
(custom RevisionInfo-Entity, set via .SetRevisionEntity<>). Therefore 
performance decreases dramatically with the number of entities returned.

I would be glad if someone could give me a hint how to solve this.

Regards

-- 
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.

Reply via email to