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]> 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]>
>
>
>
> > 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]
> > .
> > To unsubscribe from this group, send email to
> > [email protected]<castle-project-users%2bun[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].
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.