SELECT * queries waste memory and bandwidth on unused columns

Using SELECT * fetches all columns including large TEXT/BLOB fields that aren't used by the application, wasting memory, bandwidth, and serialization time.

Explicitly select only the columns needed for each view or API response. For list views, omit large content fields and only fetch them for detail views.