Need some help with pods table architecture
-
Hi everyone! I’m having some problems optimizing a Pods custom post type.
The website shows information about 180 cryptocurrencies.
I created a custom post type using PODs (thanks for creating such a great framework :cara_ligeramente_sonriente:).
So, every 10 minutes an API endpoint is called and extract the information of 180 cryptocurrencies (every cryptocurrency has 10 fields). After that I iterate over all cryptocurrencies and use $pods->save() or $pods->add() in order to update or add the cryptocurrency in the WordPress database.
The problem is that the iteration of all the cryptocurrencies takes too much time. I installed ‘Query Monitor’ and noticed that it takes to long because for every cryptocurrency field, Pods have to make a query to the corresponding field in the postmeta table. Every query to postmeta table takes between 0.05 and 0.1 seconds (depending on the field).
I know that is a reasonable time for a query. But what can I do to make the iteration faster?
Thanks
- The topic ‘Need some help with pods table architecture’ is closed to new replies.