Community

Public Snippets 1

Code shared by the SaveSnippets community — browse, copy, and get inspired.

#n-plus-1 Clear
Tags #php #kotlin #bash #go #sql #rust #typescript #html #java #python #files #utils #strings #http #concurrency #async #json #arrays #security #types #crypto #database #dates #format
SQL Window Function vs N+1 Query
Don't fetch a list, then loop in code to count each parent's children. Use a window function or a single GROUP BY — turn 1,001 queries into 1.
#sql #n-plus-1 #performance #aggregation
admin @admin ADMIN 1m ago 0
View