2 years ago

Most efficient way to get data sets

Posted 2 years ago by jbowman99

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

Please sign in or create an account to participate in this conversation.