Most AEM performance issues stem from inefficient query usage. This post explains when to use Query Builder vs SQL2, highlights common mistakes like missing indexes, fetching too much data, and running queries in loops, and provides practical best practices for optimized, scalable, and memory-safe queries in asset-heavy projects.
Engineering notes and practical guides
Best-practices
Field notes on AEM, Java, web development, performance, tooling, and the little fixes that save future-you an afternoon.
3
Articles
57
Topics
0
Featured
Featured article
Most Common Things AEM Developers Ignore When Using Query Builder and SQL2 QueriesMost AEM performance issues stem from inefficient query usage. This post explains when to use Query Builder vs SQL2, highlights common mistakes like missing indexes, fetching too much data, and running queries in loops, and provides practical best practices for optimized, scalable, and memory-safe queries in asset-heavy projects.
Read featuredBrowse the archive
Latest Articles
Check out this unique collection of useful cURL commands for Adobe Experience Manager (AEM). These commands, gathered from various sources, will help make your AEM tasks easier
Path based servlets in AEM are a security risk. Resource-type servlets enforce permissions and keep your app safe.