Skip to content

Static SQL caches grow unbounded in worker mode (FrankenPHP/RoadRunner) #27

@ahmed-bhs

Description

@ahmed-bhs

CachedSqlStructureExtractor has 15+ static array caches and SqlNormalizationCache has 7+. They are intentionally not cleared on reset() (the comment says "only strings/arrays, no stale objects").

True, but on a long-running worker processing thousands of unique SQL queries, these caches grow without limit. There's no eviction or size cap.

Should add an LRU limit or clear them periodically (e.g. every N requests).

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requestperformancePerformance improvement

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions