As Queryable. Too slow!
63 views
Skip to first unread message
samuel281
Feb 20, 2012, 2:52:06 AM2/20/12
to NoRM mongodb
Hi~!
I need a help!
I imported about 1M documents into a collection to write a Search
page.
In the Search service I call AsQueryable like below
_collection.AsQueryable().where( x =>
x.Category.Equals(category)).Skip(pageSize * pageIdx).Take(pageSize);
the code works well in usual case.
but it looks stuck when I call it with unique category value.
I made index but it was worthless.
what do you think the problem is?
I need a help!
I imported about 1M documents into a collection to write a Search
page.
In the Search service I call AsQueryable like below
_collection.AsQueryable().where( x =>
x.Category.Equals(category)).Skip(pageSize * pageIdx).Take(pageSize);
the code works well in usual case.
but it looks stuck when I call it with unique category value.
I made index but it was worthless.
what do you think the problem is?
Andrew Theken
Feb 20, 2012, 7:04:07 AM2/20/12
to samuel281, NoRM mongodb
how did you define your index?
//Andrew Theken
> --
> You received this message because you are subscribed to the Google Groups "NoRM mongodb" group.
> To post to this group, send email to norm-m...@googlegroups.com.
> To unsubscribe from this group, send email to norm-mongodb...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/norm-mongodb?hl=en.
>
Reply all
Reply to author
Forward
0 new messages