We’ve a core information entity with an attribute "description" with very very massive string saved. After we attempt to filter the entities with a predicate format similar to "description incorporates ***" then it takes round 20 seconds when the variety of rows is above 10 000.
To enhance the pace we tried including index to description, however it took truly extra time than querying with out index. Undecided it’s due to "incorporates" predicate.
We even have a requirement of fetching all of the matching rows instantly. So we can’t use fetchLimit.
Is there any various to fetchrequest predicate? Is there any higher methods to make the fetchrequest quicker?
