Some time when you are working with data centric application it is very important that the application performance didn’t get affected with the size of data to be transfered from database to your application interface.
Sometime when your data is in GB’s and you want to show that information in grid on the UI than the application takes bit of time before showing the data to the end user. For that reason there are many techniques to save as much time as one can. One solution to this problem is that you only load data on demand, means when user needs to see the data only than data loaded from the database.
The see one possible solution to this kind of problem can be found here..