Currently i have implemented jqgrid which fetches data from DB and returning the JSON data to JQGRID.

JQGrid call

```
        rowNum: 10,
        rowList: [5, 10],
        url: "/Home/GetDataFromEntity"

```

Data returned from C#

```
return Json(result, JsonRequestBehavior.AllowGet);

```

What am trying is if the page has 10 records only that 10 records i want to bring from DB and if they click to next page i want to get the next 10 data because if the data is huge i dont want to bring all data to memmory which i think will be a performance Hit.

How can i implement this ?

Thanks