Very poor performance by Nhibernate & Unitwork pattern
|July 6, 2014||Posted by forumadmin under TechQns||
I have one complex object like this
A | | | |->C(As child)---->it has 4 hastomany properties(each B has 10000 C child) B(has many child)-> |->D(As child)---->it has 4 hastomany properties(each B has 1o000 D child) |->B Has many prop also | | |A has many prop also
I, m suffering with performance. All together while retrieving this record i can expect Nh to fire 1000-2000 queries. But Worst performance by NH 10-20K queries it is firing.
Here i m doing reading and writing on entity A only. I’m not individually inserting any of A’s child nor retrival. I’m firign Get command on entity A and writing back Entity A only.
Cascading is taking care of insertion of A’s child->its child too.
here im suffering with Performace very badly, i dont know what to do here.
|Asked By – user1220402||Read Answers|