Load large Number data set From Server side

[Rajender]

Hi,

 

There are about 100000000 records in the database , i want to bring 100 records at a time and fetch next 100 with pagination each time. As i am fetching large no of data set at on g, it take lot of time to get response back from server.

[Pavlina]

Hello,

In your case I would recommend you use server paging, so that only a page size number of items are served to the client.
http://docs.telerik.com/kendo-ui/api/javascript/data/datasource#configuration-serverPaging

If paging is not an option for you you could take advantage of virtual scrolling functionality but please be aware of its limitations.
http://demos.telerik.com/kendo-ui/grid/virtualization-remote-data
http://docs.telerik.com/kendo-ui/web/grid/appearance#virtual-scrolling

Regards,
Pavlina
Telerik