What is the best way to organize the storage of a large array of data in wp?

Question

Database

It's not really a question, but rather a desire to confirm conjectures.
I want to implement a database of MMA fighters, which will be parsed from sherdog.com
Given: a site on wordpress, where most of everything is done with the ACF plugin, but using it for such a database is stupid.
However, now, for example, the import of such data is implemented using wpallimport, which perfectly supports acf and is convenient.
For now, I assume that you need to make a separate plugin with your own non-standard tables in the database, but work with it simply using what wp offers to work with the database, and use some third-party cron solution directly to the database to import it.
But ideally, I would like to spend a minimum of time to solve this problem, perhaps there are some proven solutions for organizing large data arrays, which is conveniently linked to wp and has the ability to import out of the box?

Answer 1

Hello!
- Create a table (or if you use a custom post type, then just set the post type and parse everything in wp_posts & wp_postmeta) and use wpdb to work with it (no need to use pdo)
- write your own PHP script that will parse information directly into Crown DB.
- it is not necessary to write a plugin for this business, but if necessary, you can ... you can even write mu plugin to make it "faster".