Chase Florell
Top achievements
Rank 1
Rank 1
Chase Florell
asked on 15 Aug 2008, 10:55 PM
Ok so I am wondering about efficency here.
I have a DB with over 60 Fields... I need to be able to view ALL of those fields in the NestedViewTemplate, however I am only displaying 4 (four) of those fields in the actual grid.
Since I need ALL of those records, I am currently binding my grid to a StoredProcedure where I am using "Select *"
My problem is that I don't know how effecient it is going to be when I have to call 10,000 records.
Is there a way to only call the "select * from table where ID = @ID " when the "Details" button is called?
I have a DB with over 60 Fields... I need to be able to view ALL of those fields in the NestedViewTemplate, however I am only displaying 4 (four) of those fields in the actual grid.
Since I need ALL of those records, I am currently binding my grid to a StoredProcedure where I am using "Select *"
My problem is that I don't know how effecient it is going to be when I have to call 10,000 records.
Is there a way to only call the "select * from table where ID = @ID " when the "Details" button is called?
2 Answers, 1 is accepted
0
Chase Florell
Top achievements
Rank 1
Rank 1
answered on 16 Aug 2008, 01:05 AM
Also I would like to note that I prefer to not use a DataSource in my ASPX page but rather handle it all in my code behind.
0
Hi Chase,
You can use serverondemand load mode for the hierarchy. In ServerOnDemand mode - Roundtrip to the database when grid is bound and when item is expanded. ViewState holds data for only visible Items (smallest possible). Only detail table-views of the expanded items are rendered. Postback to the server to expand an item.
Regards,
Plamen
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
You can use serverondemand load mode for the hierarchy. In ServerOnDemand mode - Roundtrip to the database when grid is bound and when item is expanded. ViewState holds data for only visible Items (smallest possible). Only detail table-views of the expanded items are rendered. Postback to the server to expand an item.
Regards,
Plamen
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.