Thursday, September 20, 2012

something random (of SQL) I remembered just now

When I was at AMD Craig Likes spoke of potentially querying for just the fields that would display in a paginated list from a table in lieu of a Select * approach in which all of the fields for a table came back in a query of numerous records. That seemed wise. This was a maybe-to-do in the name of optimization, not something to proactively do upfront. We started with the Select * approach by default.

No comments:

Post a Comment