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