How "real-time" do you need the data? Might be as simple as caching the query for X minutes or X hours depending on how often it changes - laravel supports that right out of the gate.
Tables will still cost you a query - but if you've already done the heavy lifting in another query to populate that query - that can be pretty cheap - but now you've got to factor in how that data stays in sync with what actually happens in the app - to me this one adds more logistical overhead than anything else.
Justin
Laravel, Vue.js, CSS, SASS and more...
How "real-time" do you need the data? Might be as simple as caching the query for X minutes or X hours depending on how often it changes - laravel supports that right out of the gate.
Tables will still cost you a query - but if you've already done the heavy lifting in another query to populate that query - that can be pretty cheap - but now you've got to factor in how that data stays in sync with what actually happens in the app - to me this one adds more logistical overhead than anything else.