Pods and large database

Hello,

My team and I just finished importing ~25k posts to our new WP website (the former was on another CMS) and we used pods to create a custom post type. Some of our posts have related posts so we added a “relationship” custom field to select them when creating a new post. Our issue is that it can take up to one minute to retrieve the results when searching for a keyword so it’s kinda long.

Is there a way to optimize the request ? I added an index to the post_title column in wp_post table but it doesn’t seem to affect the query in the back office. Would an object cache help ? Thank you.