Performance Issue with the Knowledge API with 100 articles per batchDescription The customer is experiencing significant performance degradation when querying knowledge articles using the Knowledge API. Transaction times increase substantially as the offset is raised (e.g., 0, 200, 300, 1000), and this issue is reproducible out-of-the-box and impacts the ability to efficiently retrieve large batches of articles. Steps to Reproduce Performance Degradation with Large Offsets: 1. Create 50,000 knowledge articles using a script that populates the `kb_knowledge` table with test data, setting the workflow state to "published".2. Install the Knowledge Block plugins and the KM REST API scoped app plugin. 3. Send API requests to `/api/sn_km_api/knowledge/articles` with varying offset values (e.g., 0, 200, 300, 1000) while keeping the limit set to 1000 and notice timing is increased a lot. WorkaroundThis issues has been fixed as part of PRB1731351 and fix is present in Java layer so there is no workaround for this issue.Related Problem: PRB1731351