laravel:performance-select-columns

What problem does it solve?

This Skill addresses inefficient database queries by ensuring only necessary columns are selected, thereby reducing memory consumption and data transfer costs.

Core Features & Use Cases

• Column Selection: Explicitly specify columns to retrieve instead of using SELECT *.
• Relation Optimization: Apply column selection to eager-loaded relationships.
• Use Case: When fetching a list of users, select only their id and name to minimize the data transferred from the database, especially in paginated results.

Quick Start

Use the laravel:performance-select-columns skill to select only the 'id' and 'name' columns when paginating users.