If you're looking to reduce the amount of sql calls your ASP WebForms page uses, you may wanna check that you're not calling the Controls property on any class that inherits from CompositeDataBoundControl. The Controls getter does the following:
- Calls EnsureChildControls.
- Calls CreateChildControls.
- Calls EnsureDataBound.
- Performs whatever data binding needs to occur.
This can eat up resources if you have a data source that's returning hundreds of thousands of rows prior to setting limiting parameters!
