I need to get several data sets from a pair of table. Table 1 will be updated every 15 minutes Table 2 will be what my api uses to show data outward.
table 1 will be what needs to be currently active -- table 2 will have all of the subsequent data attached to the active list --
I need to fetch -- whats new in table 1 that does not exist in table 2 what exists in both table 1 and table 2 and what is in table 2 and not in table 1
each table will have an id that can be matched in both tables
should I join sets, intersect arrays, array_diff. beginning with a few thousand entries climbing to hundreds of thousands of entries