I have a parent child gridview that functions fine, but it is very slow with a large parent recordset.

I believe the problem is that my database is queried numerous times to populate the child gridview using OnRowDatabound.

The data for parent and child uses a common key to maintain relationships:

Parent table: Trust

Parent key: ID

Child table: Loan

Child key: TrustID

Is it possible to pre load or load the data from the database once and store in session or cache to populate each nested row ?