[Spike]: Performance Analysis and Optimization Strategy for Folder API Operations

Task

Purpose

Conduct a comprehensive performance evaluation of existing folder APIs and design optimization strategies for the new Folders REST API, especially for heavy operations involving large folder structures.

Goals

• Performance test existing /api/v1/assets and /v1/folder endpoints with various folder sizes
• Benchmark current deletion operations for large folder structures
• Evaluate async processing capabilities for heavy operations
• Analyze memory and CPU usage patterns during folder operations
• Design performance optimization strategies for the new API

Acceptance Criteria

• [ ] Performance test results for existing APIs with small, medium, and large folder structures
• [ ] Benchmark analysis for operations on folders with 100K+ assets (as mentioned in comments)
• [ ] Memory and CPU usage analysis during heavy operations
• [ ] Performance comparison between different folder retrieval methods (URI vs path)
• [ ] Async processing capability assessment for large deletions
• [ ] Performance optimization recommendations for new API implementation
• [ ] Caching strategy recommendations for frequently accessed operations

Parent Issue

Subtask of #32302

Start by reviewing the existing /api/v1/assets and /v1/folder endpoints and defining test cases for small, medium, and large folder structures. Benchmark retrieval and deletion, including folders with 100K+ assets, while recording CPU and memory usage. Done means documented comparisons, async and caching assessments, and optimization recommendations for the new Folders REST API.