default behavior of the template grid is as required, each page loads on paging.
You can set the nr of show rows in template grid widget.
Retrieve of data can be improved using indexes on the entity. Index should be on sorting attibute of template grid
when you click next page, Is this will work for retrive data only 3 rows? or This will read all data at one time and just show 3.