Hypothetical question: Grid performance under two different scenarios

[Boris]

I'm looking at the following demos.

http://demos.telerik.com/aspnet-ajax/grid/examples/hierarchy/declarativerelations/defaultcs.aspx

http://demos.telerik.com/aspnet-ajax/grid/examples/programming/selectedvalue/defaultcs.aspx

I have the usual header-detail relationship in a pair of tables.

I was just wondering if there are any performance issues I should be aware of when chosing one method over another? 

(It's quite likely that most of the headers may have only a few details.  It is also possible a few could have dozens.)

[Vasil]

Hi Boris,

You should be aware that with the default paging in this demo all records are retrieved from the database. Then the grid pages them and shows only the current page.

If you have lots of records there will be a performance penalty. You have either use LinqDataSource, or implement custom paging.

All the best,
Vasil
the Telerik team

[Boris]

I went with the first type and LinqToSQL.  Seemed simpler.