Where is the processing happening?

[SteveInBeloit]

If I put the Select command in the VB .NET code, such as "Select col1, col2 From Orders INNER JOIN OrderDetails ON OrdKey = DetOrdKey Where yada...."

and fill a Datatable with this, are all the records being pulled back through the network, and sorted out on the client?

If so, if I write a stored proc instead, won't that shift the processing to the server?

Thanks.

 

[cjard]

the command text "SELECT..." is sent to the server, where it is compiled, planned and executed. If you can ensure it is parameterised then the compilation and planning happens only once. The server builds the results, and returns the data. Sorting and filtering can be done locally, by a BindingSource