Custom table vs posts

by AndyW   Last Updated March 29, 2018 22:08 PM

I know this question has been asked before but I have a few additional parameters which may affect the answer.

I'm developing a plugin which utilises the wp api to update the data I want to display. The site will be using a caching plugin. The data could change every few minutes but more likely at least twice an hour. The data could will be queried all the time by the users (min price, max price, etc). I've seen i can programmatically clear the cache in certain caching plugins FYI.

In terms of data structure it's fairly simple. In traditional terms the bulk of the data would be held in one table (perhaps 50 fields). Plus another table which contains media for the main record (perhaps 5 fields). Most queries would use numeric fields to filter, price the most common.

Now given I prioritise performance and showing the most recent changes would I be best with a custom table or using posts and post meta?

I hope that all makes sense.

I'll be doing some testing but thought it might be better to get some input rather than discover 6 months down the line I should have done it the other way.

Related Questions

Any reason why wp_cache_set not to work?

Updated October 27, 2017 15:08 PM

String Replace Caching & Chance of Collisions

Updated June 09, 2015 23:03 PM

Extremely slow Wordpress website with 6000 posts

Updated May 04, 2017 10:08 AM