Editor Grid - Paging Shows All Records

Editor Grid - Paging Shows All Records

I've read post after post and tried to follow the examples to the letter (Tutorial, Docs, forum) but I'm banging my head against the wall with paging the editor grid. I've managed filtering, adding rows, editing in line but paging is killing me so I'd be eternally grateful for some help.

Preliminary question: Is the paging done server-side with the offset and limit passed back to the server going into say a SQL query's limits or is it done client side with the whole dataset?

I've tried doing it both ways:

1. Server Side
I tried using the "start" and "limit" post data in my SQL query on the server which then returned 10 records as expected. I then did a query to find the total number of fields in the table which in my case was 16. So my JSON returned:

However, the grid displayed just the 10 records and said only 10 were available. So no paging.

Then I tried....

2. Client Side
I ignore the "start" and "offset" values sent back as post data and simply send all records to the grid. Now I have something more promising because the grid detects all 16 records and that it should be put across 2 pages as it enables the paging button and shows "1 - 2" for the pages. However, it shows all the records - so its not paged. If I go to page 2 it just shows them all again.

So neither way works - I'm hoping someone could let me know what I'm doing wrong? If you need to see my code then let me know what part and I'll post it up - I just don't want to swamp you all with it in one go.

pagins is handled on the server side; the idea is to reduce the amount of data exchanged with the client.
it would help to see the config for your store and reader objects, particularly the reader's totalProperty property.

pagins is handled on the server side; the idea is to reduce the amount of data exchanged with the client.
it would help to see the config for your store and reader objects, particularly the reader's totalProperty property.

You're an absolute star - thank you so much!

I'd completely omitted the total property - something that had me running in circles chasing mirages here and there. Added that and its now working perfectly. Thanks again - you've been a great help.