I would like to ask if there is any powerful method we can use to combine the Id's to a single field for faster search and retrieval.
My case is like this, I have a table that stores ID's of companies.
ID | CompanyName
1 | Company A
2 | Company B
3 | Company C
I have another table where there is data that need to be processed by these companies. so i am looking for a better method to find the data that is not processed by a specific company.
Data | CompaniesProcessed
A | 1,2
B | 3,2
C | 3
one easy way i can think is store the company ID's as a separated value and search for it. The data set to search can be huge, so, Is there any other way that will be faster for search rather than the string operation?
EDIT: I need to read through data and check if it is already processed for a specific company. so if this is linked table i have to do a read operation of data and search the linked table to know if it is processed. However, if it is in a single table, i can just filter out those records that are processed while i read.