I have a scenario where there is a query with certain names of instances stored in a string field. Now i have to extract the corresponding ids for these instance names in the query from cmdb table and store it to process it at a later point. There could be upto 100k names in that instance list. Whats the most ideal way to handle this? Should i extract the ids and store it in a separate string field in the same table? Or create a new table to map a set of ids? Please advise.
example query : u_nameINinsxyz,insxyz2,insxyz3... (upto 100k)
expected instance ids list :
"f918b7341be7fcd07504751f034bcbbb,f918b7341be7fcd07504751f034bcbbb..." (upto 100k)
Am skeptical if its good practice to store such long strings.
