Unlrelated to the issue at hand, but Markus, could you move the
documentation for AR to stw wiki?
Krzysztof
On 2010-05-30 20:09, Markus Zywitza wrote:
This usually means that there was no common session available for
loading the instances lazily. You have to use either SessionScope or
IConversation, depending on the type of application.
http://www.castleproject.org/activerecord/documentation/trunk/usersguide/scopes.html
http://using.castleproject.org/display/AR/Using+the+Conversation+Pattern
-Markus
2010/5/30 raghavsri <[email protected]
<mailto:[email protected]>>
Thanks for your reply
i used lazy loading,performance was really improved a lot,
but some instances i am getting
NHibernate.LazyInitializationException ..in my implementation.
Please let me know if you have any suggestion, how to handle the
things when we use lazy loading
Once again thaks for you quick response...
Regards
Raghavendra
On May 29, 12:11 pm, Markus Zywitza <[email protected]
<mailto:[email protected]>> wrote:
> You have to use lazy loading. With the current mapping, if you
load one
> sample, AR loads all the tests assigned to it, then for every
test it loads
> all the machines associated with them and then for all machines
of all tests
> of this sample it loads all results.
>
> If you had many-to-many relationships, this would be even worse,
because
> then all other reachable tests, computers and samples would be
loaded. But
> even so, you are getting a good bunch of data into memory with a
lot of
> queries.
>
> Performancewise, all HasMany-attributes should have Lazy=true and
> Inverse=true. Ayende has written some posts on inverse and
lazyloading for
> NHibernate. Since AR uses NH, these posts are very useful. You
might also
> want to try NHProf for performance profiling with AR if lazy
loading does
> not bring enough performance.
>
> -Markus
>
> 2010/5/29 raghavsri <[email protected]
<mailto:[email protected]>>
>
>
>
> > In sample class to map sample
>
> > [HasMany(typeof(Test), Table = "Test", ColumnKey = "SID",
Inverse =
> > false,
> > Cascade = ManyRelationCascadeEnum.All)]
>
> > In test class to map sample
> > [BelongsTo("SID", NotNull = true)]
> > public virtual Sample Sample
>
> > in test class to map mahcine
> > [HasMany(Table = "Machine", ColumnKey = "TID", Inverse = false,
> > Cascade = ManyRelationCascadeEnum.All)]
>
> > in machine class to map test
> > [BelongsTo("TID", NotNull = true)]
> > public virtual Test Test
>
> > On May 29, 2:48 am, raghavsri <[email protected]
<mailto:[email protected]>> wrote:
> > > following are the list of table
> > > sample--->test-->machine--->result
> > > user
>
> > > sample has 1 to many relationship with test ,
> > > test ,1 to many to machine
> > > machine ,1 to many result
>
> > > apart from this test is also associated with user table
>
> > > I have inserted more than 1000 rows in all these table
>
> > > when i say
> > > ActiveRecordBase<Sample>.FindOne
> > > (
> > > new ICriterion[]
> > > {
> > > Expression.Eq("SerialNumber",
serialNumber)
> > > }
> > > );
>
> > > it is taking lot of time,
>
> > > On May 29, 2:17 am, Markus Zywitza <[email protected]
<mailto:[email protected]>> wrote:
>
> > > > Sorry, my crystal ball is off duty right now. Can you
please send us
> > your
> > > > mappings and your usage scenario?
>
> > > > -Markus
>
> > > > 2010/5/28 raghavsri <[email protected]
<mailto:[email protected]>>
>
> > > > > Hi
> > > > > I am experiencing very poor peformance ,when i am using
FindOne and
> > > > > FindAll fucntionality ,in activerecord.
> > > > > there are only 4 cascaded tables and these functions are
taking more
> > > > > time even with small amount of data(1000 Rows in database. )
> > > > > Please can somebody tell me ,what is the actual problem.
?(Logging is
> > > > > switched off)
> > > > > Regards
>
> > > > > --
> > > > > You received this message because you are subscribed to
the Google
> > Groups
> > > > > "Castle Project Users" group.
> > > > > To post to this group, send email to
> > [email protected]
<mailto:[email protected]>
> > > > > .
> > > > > To unsubscribe from this group, send email to
> > > > > [email protected]
<mailto:castle-project-users%[email protected]><castle-project-users%2bun[email protected]
<mailto:[email protected]>>
> > <castle-project-users%2bun[email protected]
<mailto:[email protected]>>
> > > > > .
> > > > > For more options, visit this group at
> > > >
>http://groups.google.com/group/castle-project-users?hl=en.-Hidequotedtext
-
>
> > > > - Show quoted text -- Hide quoted text -
>
> > > - Show quoted text -
>
> > --
> > You received this message because you are subscribed to the
Google Groups
> > "Castle Project Users" group.
> > To post to this group, send email to
[email protected]
<mailto:[email protected]>
> > .
> > To unsubscribe from this group, send email to
> > [email protected]
<mailto:castle-project-users%[email protected]><castle-project-users%2bun[email protected]
<mailto:[email protected]>>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/castle-project-users?hl=en.-
Hide quoted text -
>
> - Show quoted text -
--
You received this message because you are subscribed to the Google
Groups "Castle Project Users" group.
To post to this group, send email to
[email protected]
<mailto:[email protected]>.
To unsubscribe from this group, send email to
[email protected]
<mailto:castle-project-users%[email protected]>.
For more options, visit this group at
http://groups.google.com/group/castle-project-users?hl=en.
--
You received this message because you are subscribed to the Google
Groups "Castle Project Users" group.
To post to this group, send email to
[email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/castle-project-users?hl=en.
--
You received this message because you are subscribed to the Google Groups "Castle
Project Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/castle-project-users?hl=en.
