PagedSearch search big data is very slow about mongodb.entities

[dj-nitehawk]

how long does it take if you do PagedSearch without the Sort?
i'm assuming most of the time is spent on the sorting.
does the situation improve if you index the OrderId field?
btw, this is a mongodb server thing and has nothing to do with this library per se.
try to profile the actual mongo query received by the mongo server and try to optimize it before you actually try to query data using .net/c#. that way you'll get an idea of what's the expensive operation that takes time.

you can use the mongo shell to see the latest queries received.
1. enable db profiling with db.setProfilingLevel(2)
2. see last 5 queries with db.system.profile.find().skip(1).limit(6).sort( { ts : -1 } ).pretty()

[uServe-UP]

how long does it take if you do PagedSearch without the Sort? Will get an error "Paging without sorting is a sin!"
does the situation improve if you index the OrderId field? "I have index on the OrderId field"

I will try your suggest Thank you

[dj-nitehawk]

also try the find query with the same sort and see if the time increases.

[uServe-UP]

also try the find query with the same sort and see if the time increases.

Find is very fast

[dj-nitehawk]

this is basically what the pagedsearch method generates: https://stackoverflow.com/a/48307554

try profiling to get the actual generated query and run it in the db. see if there's any clues there for the slowdown.