I have reached a conclusion and I will share my findings for anyone who visits this page later and seeks an answer.
Enabling the “Watch changed fields for use in hooks” option allows the Pods plugin to keep track of changes made to the values of these fields, so that they can be referenced later using PHP hooks. In other words, when you make changes to these fields and save them, the plugin will have a record of what the previous values were. This information can then be accessed and used by other plugins or custom code via the PHP hooks provided by Pods.
in my case I did not need that so I disabled that.
The “Watch WP Metadata calls” option determines whether the plugin will monitor metadata calls made by WordPress, and the “Override WP Metadata values” option determines whether the plugin will override metadata values with the values it is tracking. If you do not use table-based Pods and only want to query metadata-based Pods or settings, you can disable these options. This will prevent the plugin from monitoring metadata calls and updating table-based fields, which can improve performance.
Table-based Pods are a type of custom content type created using the Pods plugin for WordPress. Instead of storing custom data as metadata in the WordPress database, table-based Pods store the data in separate database tables, which allows for more advanced querying and manipulation of the data.
For example, consider a movie review website that uses Pods to store information about movies. A table-based Pod could be created to store information about each movie, such as the title, release date, director, and IMDb rating. Instead of storing this information as metadata in the WordPress database, the information would be stored in a separate database table specifically for movie information. This allows the website to easily query and display information about movies without having to retrieve and process metadata from the WordPress database.
To determine if you have table-based Pods in your WordPress website while using the Pods plugin, you can follow these steps:
- Log in to your WordPress dashboard.
- Go to the “Pods Admin” menu in the WordPress admin menu.
- Click on the “Pods” option.
- In the “Pods” screen, you will see a list of all the Pods you have created for your site.
- Look at the “Storage Type” column for each Pod. If the storage type is listed as “Table”, then it is a table-based Pod. If the storage type is listed as “Meta”, then it is a metadata-based Pod.
I checked this column for my Pods and all of them were listed as “Meta”. so I disabled this option. (by disabling this option “Override WP Metadata values” will be disabled as well.)
now I can see that the website is much faster and also search over custom post types are a lot better.