How does this skill help with slow JUDO queries?

It provides a diagnostic framework to determine if your query should use Embedded JOINs for speed or SubSelects to avoid Cartesian products, while also checking for early filter placement.

When should I use CustomJoinDefinitions?

CustomJoinDefinitions are recommended for deep or complex navigation chains where standard automated joins lead to performance degradation or complex SQL requirements.

What is the benefit of static navigation caching?

Static navigations lack runtime variables and can be pre-computed at startup. This skill helps you identify these opportunities to reduce request-time overhead.

How does expression optimization work in JUDO?

It involves propagating constraints like precision and scale through functions and only applying measure conversions when units actually differ, reducing unnecessary calculations.

Can it help solve the N+1 query problem?

Yes, it guides the implementation of SubSelects with batch loading parameters, which are built into the JUDO QueryFactory to handle collection references efficiently.

JUDO Query Optimization

Name: JUDO Query Optimization
Author: BlackBeltTechnology

byBlackBeltTechnology

データベース管理

Optimizes JUDO query performance by analyzing join strategies, caching mechanisms, and expression evaluation patterns.

概要

The JUDO Query Optimization skill provides specialized guidance for improving the performance of the JUDO runtime. It helps developers diagnose slow queries by identifying the optimal use of embedded joins versus subselects, managing query caching for static and dynamic navigations, and tuning expression evaluation precision. By addressing common performance anti-patterns like N+1 queries and circular aggregations, this skill ensures that data-intensive applications built on the JUDO platform remain performant and scalable.

主な機能

Expression optimization and efficient measure conversion scaling
0 GitHub stars
Query caching management for transfer objects and static navigations
Detection and resolution of N+1 query and circular aggregation patterns
Automated join strategy selection between Embedded JOINs and SubSelects
SubSelect aggregation placement to prevent row multiplication

ユースケース

Tuning expression evaluation precision and scale for high-performance measure conversions
Implementing complex data navigation paths using CustomJoinDefinitions and batch loading
Diagnosing and resolving performance bottlenecks in slow JUDO database queries

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add blackbelttechnology/judo-runtime-core query-optimization

For use in Claude.ai and ChatGPT

Download Skill

GitHub

概要