DataGrid Pagination using Mongo dB

Question

I've a wpf app and mongo db as back end, if i call a query to mongo db from wpf app it giving me million of records so currently i'm using normal pagination like storing all data from db into data table and doing pagination. But if system having less memory its impossible to store that much of records, so some body says to me that mongo db provides pagination means we can call records directly from db when user clicks next or previous so any one help me to do this.

score 1 · Accepted Answer · answered Jan 10 '12 at 15:02

1

You can use mongodb's limit() and skip() to implement paging. For example, to get the 3rd page where page size is 10, you'd use this query:

db.your_collection.find().skip(20).limit(10)

answered Jan 10 '12 at 15:02

milan

11,872
3
42
49

score 1 · Answer 2 · edited Jun 20 '20 at 09:12

1

There are two kinds of paging:

Via limit and skip, just like @milan proposed.
Via range query:

db.items.find({created: {$gt: startDate, $lt: endDate})

Range queries will work faster then skip, because they are no need to move towards 'skip' item.

Look into related thread as well.

For your case if you have only next/prev buttons range paging should be good option.

edited Jun 20 '20 at 09:12

Community

1
1

answered Jan 11 '12 at 08:29

Andrew Orsich

52,935
16
139
134

can you plz provide me sample for range paging. – nag Jan 11 '12 at 10:06
@nag: see mongo shell example in my answer above. – Andrew Orsich Jan 11 '12 at 10:33

DataGrid Pagination using Mongo dB

2 Answers2

Linked