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.

Reply via email to