[Resolved] Can a large database that is updated every 15 minutes be mapped to Types?

[Author]

Posts

[laurieH]

Tell us what you are trying to do? I am building a real estate website that will access data from 1-2 RETS feeds from MLS providers. This is a lot of data and it can be updated as often as every 15 minutes. For a variety of reasons, I am choosing not to use an IDX provider. The current development plan being evaluated is to store the data in a separate database and to use CRON jobs to keep the data updated.

My question for Toolset: Will I be able to map the tables/fields in the database to Toolset Types so that I can use Toolset and Elementor to display the data? What have you found to be the best way of building a site with a large dataset that is being updated very often that leverages Toolset?

Thank you for your time 🙂

[Luo Yang]

Hello,

Toolset Types plugin can not map the data from another separate database, there isn't such kind of built-in feature within Toolset plugins.

Here are my suggestions:
1) Create a CRON job to load the new data from your data providers(MLS providers/IDX providers)
https://developer.wordpress.org/plugins/cron/

2) Put those new data into your website database, for example:
Insert new posts:
https://codex.wordpress.org/Function_Reference/wp_insert_post
Add post meta:
https://developer.wordpress.org/reference/functions/add_post_meta/
Setup terms of taxonomies:
https://developer.wordpress.org/reference/functions/wp_set_object_terms/

Notice: If the custom fields are created with Types plugin, you will need to add prefix "wpcf-" before the field slugs, for example: a custom field "my-field" created with Types plugin, in database table "wp_postmeta", in column "meta_key", you will need to use value "wpcf-my-field".

3) Then display those data with Types/Views shortcodes:
https://toolset.com/documentation/customizing-sites-using-php/functions/
https://toolset.com/documentation/user-guides/views-shortcodes/

[laurieH]

My issue is resolved now. Thank you!