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.