Ordering of limit and sort has any effect in query execution

[Sandy]

Hi

Does Ordering of limit and sort has any effect in query execution

Are both queries same or different

1) db.foo.find( { _id: { $gt : "ABCD"} }).limit(4).sort({_id:1})

2) db.foo.find( { _id: { $gt : "ABCD"} }).sort({_id:1}).limit(4)

Thanks
Sandy

[Sid]

It shouldn't. You can verify this using explain on the queries. Here's the page that tells what explain returns : http://www.mongodb.org/display/DOCS/Explain